Formula to search multiple worksheets in workbook

I really don't know if this is possible (fingers crossed it is and its easy..LOL)

I have 150-200 clients. I am taking their YE financials and condensing them into a shorter "version". Each client will have their own worksheet in my Master. I want a formula that based on client ID would search the entire workbook (each worksheet) and pull the corresponding data depending on what I am looking for. It needs to match ID and then match up "acct".

I have attached a sample. My auto form is what I need filled out based on what ID I enter. I need it to search each sheet for the corresponding ID in A1 and then search for the approp Acct.


Thoughts??