I have a spreadsheet that has multiple tabs with the same data on each 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 columnar 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 of rows.
The data fills in landscape across the columns instead of row after row
as it was input.

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

Any help would be appreciated.