DELETED - Standardize a File

Hi nattiej101 

I see you raised 'a bit of a problem...' twice (it's useless) already

In principal reformatting data is something that can be done with Get & Tranform (aka Power Query) and maybe with VBA or Office Script

I looked your 2 files to get a sense of the feasibility with Power Query. Each file has > 1 sheet and you don't say which one(s) contains the data to 'capture'. If it's sheet 'Assy WA Data' this sounds doable*, for the others this looks (almost) mission impossible IMHO

* For sheet 'Assy WA Data' I can take a look at doing it if you indicate which columns should be captured (in each file) + for April 2021 what should be the header for the 1st column:

NB: Assuming I can do it for the 2 files you shared, if your other ones are not formatted the same you will have to adapt to queries...