Need a Macro to Copy and Paste Monthly Income Statements into 5 Columns and Many Rows

Hello,

I have a model for an 3 unit business, where each unit has its own income statement. Each income statement has approximately 100 rows of revenue and expense line items and 24 columns for each month between January 2011 - December 2012. What I would like to do is have each revenue and expense item for each month for each facility as a separate line item.

Column Headers: (1) Unit Name (2) Revenue or Expense Line Item Name (3) Year (4) Month (5) $ Amount.

I have attached a sample file for reference.

I appreciate any advice on this.