Pulling data from multiple sheets

[fargo]

I have a workbook with multiple sheets that have dates as names. In each one of these worksheets is a table set up like so:

Date x
----------building 1 building 2 building 3
occupied
vacant
total

What I want to do is create a table that has all the data for a given building pulled off of all the worksheets (thus the x-axis will be dates instead of buildings). The buildings sometimes located in different columns in different sheets.

Thanks for any help.