Hi sorry for the confusion.

It would be all the data in the sheet, then that data pasted values and formats (get rid of formulas)

So just as 1 example.

I go to the data spreadsheet "machines"

I go to tab, "area1", I copy and paste all the data, everything and paste values and formats into a new spreadsheet named "area1".

I then go back into the data spreadsheet do the same for "area2" until I get to no 56.

I then go to the next data spreadsheet "expenditure", I do the same as above etc for 20 different sheets.

I'm not sure if its possible to do a macro for all of this in one.

Or whether you need a macro to do the job for each data spreadsheet.

Need them in a certain order as well