Dynamic Links across several Worksheets and Workbooks

I posted these spreadsheets once before, but I have come a bit farther and would like further advice. There are now four spreadsheets and I re-worked to have one master data entry worksheet. I am still wondering if that was the correct call. Before my question dealt with copying the room names and numbers and somehow ensuring that the data from two spreadsheets would stay associated to the correct room as revisions are made. The four spreadsheet are as follows:

1. Programming Worksheets ( for data entry )
2. Programming Reports ( for printing the finished data )
3. Space Requirement Data Sheets ( pulls relevant data using VLOOKUP from the Programming Worksheets using a simple drop-down )
4. Equipment Lists ( also pulls relevant data after selecting from a simple drop-down )

My struggle is between the Programming Worksheets and Programming Reports. The reports should automatically generate; it should copy, filter, and sort the data as it is entered. VLOOKUP or INDEX/MATCH doesn't seem to be the right fit; there is no data present to search against. I would have to manually enter the room list twice ( once in Programming Worksheets and once in Programming Reports ), I think. Please tell me I am wrong. An array copying the data almost works, but despite the named range dynamically updating from the Programming Worksheets, the cells selected in Programming Reports do not. This is how the file is currently set up. Thus, the rooms at the bottom get cut off as new rows/rooms are entered in Programming Worksheets. Lastly, I just spent hours testing Get and Transform. It certainly pulls and copies my data, but if this file is to stand as a template ( it will be empty in the beginning ), it will always have duplicate blank entries and cause errors. Therefore, anybody using this so-called template would have to re-apply the complicated Get and Transform process. I think.

Since the last time I posted, my firm just updated to Offfice 365, so Get and Transform is now an option. My gut tells me I need to learn VBA at this point. The goal is automatic, simple, and dummy-proof.

Please ask me questions and point me in the right direction. Please find all four files ... though the first two are really where the problem lies. This should be a fun one for those who like a challenge.