Creating MasterWorksheet from multiple worksheets by common headers

Hi all,

I created a template for a master worksheet and manually the task i need doing would mean opening many worksheets and manually copy and pasting columns of data and putting them under the corresponding headers in my master worksheet. I started to write a Macro to do this for me but can't get it to work on the simple example I made.

Basically what i have written should:
Examine the header cells from the source sheets, compare it with the header on my mastersheet. If they are the same (match) then copy the data from that column of the source sheet and paste it underneath the mastersheet header that matches. Then repeat this until all the cells are checked. If they dont match then keep looking.

ANY help would be amazing, this is stopping me from moving on with the project.

thanks
>>files attached:Headers for both sheets are known as the LQ:ID (what i'm joining them by)

Hi,

You need to upload your master workbook and a representative example of one of your source sheets.