vba to copy data by specific headers to a master sheet in same workbook

Hi All

I have a workbook in which there are same headers with multiple worksheets, I have master sheet to compile data by specific headers .

The issue are that the headers are not in same columns in the worksheets (e.g supplier in sheet ref aa can be at column B and on sheet ref bb can be at column C, much more sheet ref aa can have headers alcohol_1 but sheet ref bb does not have that header).

See attached sheet for ease of understanding , have a sheet with variance of headers of columns .

The only headers that need to be pulled are in yellow, some may be blank but need to be copied.

Any assitance in vba would be helpful to solve this tedious task

Thanks if any can help

Originally Posted by AB33

Try the attached.

Thank you