Multiple Tabs - Data combine

[zero760]

I have a spreadsheet that has multiple tabs with the same data on eac
tab. The data is input line after line. Example appears below;

Name : John Smith
Address : 123 Main Street
City: Anytown
State: Ca.
Zip: 12345

I need to gather the data from each tab and put it into a columna
format
that looks like this

Name Address City State Zip
John Smith 123 Main Street Anytown Ca 12345

Basically the data ends up fitting nicely into columns instead o
rows.
The data fills in landscape across the columns instead of row afte
row
as it was input.

I can then make a relational database out of the data. I have trie
the
=(cell#) and have tried to make the cells absolute on the referenc
but
it does not work.

Any help would be appreciated.

Thanks,

Damio