Hello

My workbook has old code which did achieved what I still want to achieve however the format of the workbook/sheets has now expanded/changed so I am looking for the code to be amended (or new code if required).

The aim is to pull data from 8 sheets (W1>8) and show in a new sheet (manpower import) in the relevant order and columns.

In sheet (manpower import) I have put an example of the desired result (columns L-Q), which should appear in columns B to G. The import button is existing from the old solution.

If any sheets need to be unlocked the pw for this example doc is open.

Help would be very very appreciated, as I unfortunately just don't understand code!!