I have 1 workbook with 5 sheets.
What I want to do is combine all these data to 1 sheet.
How will I do that with Macro?
Columns in all my sheets are identical
My columns are
A B C D E F
Market Desc Local Profile Item Inventory Quantity