I have a project I am working on and need some help getting some clarification... I think I have over thought this. I have a workbook with multiple sheets that are identical, and will continue to add sheets as people are assigned. There are 8 sheets that I do not need to transfer data (excluded from macro including two master sheets). I will assign a button to execute the macro on each "Master" sheet. I have been able to write the code for all columns from all sheets to one sheet but adding the dynamic of certain columns to different columns in the output is more difficult that originally thought. Thanks for any guidance in advance.

All sheets in workbook excluding "Sales Recap", "Item Forecast", "Items", "Divisions", "JDA NIF", "Instructions"
As well as the two master sheets "Master sales Projection" and "Master Supplemental Requests"

Columns from all Sheets - To "Master Supplemental Requests" Header is in row 5
A---> C
I---> E
J---> F
K---> G

Columns from all Sheets - "Master sales Projection" header is in row 4
A---> C
M---> E
N---> F
O---> G
P---> H
Q---> I
R---> J
S---> K