Auto expand table based on amount of rows of data provided

Hi Ant,
created a workbook with a procedure to create the CostCenter Reporting Workbook from scratch.
For me a good opportunity to dig more into power query and should save you a lot of work.
Have a look at it and just run the procedure.
If - like you say - you have done some basic things with vba then it shouldn't be too hard to follow with the procedure is doing.
More detailed info is on the ProcCenter sheet.
Don't forget the change the folder paths to your needs.