Pulling data from multiple sheets to a master but more difficult than that

OK so i work for a casino and I need to update a workbook with multiple sheet. The master is stripped down to SSN and then the deductions associated with that SSN. The other sheets in the workbook provide names and more information about the types of deductions an so on. I would like the master to auto fill the deductions from the other sheets based not on the cell but the SSN saying outloud makes me think this in untenable but I can at least ask. I dont want to have to go through all the entries for the master sheet and enter a new formula if i dont have too. I see it as an if this than sort of situation. Like if this SSN is present on the master sheet then fill these other cells with the appropriate information from the other sheets. 

By: Markus Potter

Leave a Reply

Your email address will not be published. Required fields are marked *