Pulling data from multiple tabs

I have a spreadsheet that has about 100 tabs. Each tab represents one person and their personal info, i.e. Name, Address, Phone Number... What I need to do is create a new spreadsheet that contains everyones Name and Address on one tab.

Currently, the data is like this, one person per tab:

A
2 First Last
3 Street Address
4 City, State Zip

What I need to turn it into is this, with everyone on one tab.

A B C
2 First Last Street Address City, State Zip
3 First Last Street Address City, State Zip
4 First Last Street Address City, State Zip
5 First Last Street Address City, State Zip
6 First Last Street Address City, State Zip

Is there a way that I can run a macro to move from tab to tab and pull the data from the required fields?

Thanks,
Jeff