Posting Data to a Master Table from Different Formats

[mlerickson]

I have two spreadsheets that track data for costs/expenses. The first worksheet tracks data in this way: Months for an 18 month period across the top as headings with Location 1 Expense Categories (Hardware, Software, Interest, Contingency), Location 1 Capital Categories (Hardware, Software, Interest, Contingency), Location 2 Expense Categories (Hardware, Software, Interest, Contingency) and Location 2 Capital Categories (Hardware, Software, Interest, Contingency) as rows. The second worksheet tracks data in this way: As headings across the top Location 1 Capital, Location 2 Capital, Location 1 Expense, Location 2 Expense with rows that track the same 18 month period but listed as weeks not months. I need to make one pivot table that pulls in the data from both worksheets. I've tried consolidating them onto one worksheet but I've run into trouble trying to consolidate the weeks into months. Any suggestions?