I have a spreadsheet that I have used VBA to do most of the leg work to get to a point where I can run it but I am missing one piece. I have few hundred sheet tabs (each one is an account) and I need to pull all these into a summary page (account name is in cell A1 on all sheets) and pull the account name and the 5 different subtotals I have on each sheet into one summary page.

I.E: Cell A1: John Smith
(different cells each sheet)
Total Cash $x
Total Real Estate $x
Total Personal $x

Would like to get a sheet that says:
Total Cash Total Real Estate Total Personal
John Smith $x $x $x
Steve Smith $x $x $x
Joanne Smith $x $x $x

Be also nice if I could find a way to household them so say the 3 were family and I wanted to only look for those names and then import only the data each time and keep the household. (separate questions)

Thanks!