Auto expand table based on amount of rows of data provided

Further to Q2:
The attached new version has a Total column for each month in the template and the macro now copies the formulas of the first row to all the cells in
columns 1 - 84 (see code snippet below).

'Copy the formulas from the first row throughout all Account/Period columns and rows
Range("PQ" & CostCenter & "[[Column1]:[Column84]]").Resize(1).Copy
Range("PQ" & CostCenter & "[[Column1]:[Column84]]").PasteSpecial