Need VBA code changed to work on new workbook format

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!!

Trying to upload file to this thread it keeps saying upload failed. Attempting in xslm and zip but both keep failing to upload. Am I missing something here?

Hello,

just follow the top page yellow banner …

Hi Marc

I have but it just keeps saying upload of file failed. Zip file is within file limits so no idea why is failing to upload.

Maybe its size ?