Find Data on One Spreadsheet Based on Name & Place into Another Spreadsheet

Hi,

I am trying to find the best way gather data from one spreadsheet and place it into another. I have a person's name and data associated with that person. What I want to do is take data generated via our company's database that is organized via different names and data associated with these names, and place that information into various other spreadsheets based off these names. Is there any good way to do this??? The main issue is that the database produces a different spreadsheet every time you ask it for the information. The good thing is that the information is produced in excel but it is a crazy format though!!

I came up with an idea one time about using an if statement to get the data and just update the links on it each time. I can't remember how I did it or if it was the best way. Please help me if you know of something. Thank U - SEOT

Different Workbooks....I really appreciate any help you can give. - SEOT

I did find what I used before to make this work, but I know there has to be a better way. Here is the formula used:

IF(A7 = "name looking for", "C: path", "error message if not found in other workbook")

Then, I just updated the links. I know there is an easier way to do this. Does anyone know of something else to try. Thanks