Hello!

New to this forum but certainly not new to excel. I have a task that I think would be good for a Macro but I'm not sure if it's even possible - much less how to do it. Here's what I have:

We have multiple workbooks, one for each deal we do. Each deal has several clients, which are separated into different worksheets. For example, I have workbooks that say House #1, House #2, etc, and within each workbook I have Clients like John Smith, Sally Jones, etc which are the name of the worksheets. John Smith's worksheet has all his information, Sally's has hers.

I want to create a macro in a new workbook that when I enter a client's name will fill in the other information based on the workbooks where the client is listed. So essentially, I enter in the client's name and the macro would go through the selected workbooks and pull out only information relevant to that person (amount of money paid, interest rate earned, etc). Is this something a macro would be able to do? IF yes, how can I get started?

Thank you!