Getting Macro to dynamically adjust to a new row

Does the attached work for you? It takes values from certain cells in the Room worksheets and adds linking formulas to the Totals sheet. You'd need to already have all the Room worksheets in the workbook and ensure that they are positioned between the Temp_tables and the Totals worksheets.