Automated Multi-Sheet Excel Merger
Budget: ₹600 – ₹1,500 INR
I have four separate spreadsheets that each hold mixed customer details. I need them brought together in a single .xlsx workbook where:
• each original file sits in its own clearly-named tab, untouched except for formatting consistency, and
• a fifth tab automatically pulls the data from those source tabs, stitching everything together through the columns common to every sheet—Name, Company, amt, date, and email.
The combined tab must expand seamlessly as fresh rows are added to any of the source tabs throughout the year. I’m happy for you to tackle this with formulas, Power Query, or another repeatable method, as long as I can simply paste updated data into the individual tabs and see the master list refresh without extra clicks.
Deliverables
1. Finished Excel workbook with the four raw-data tabs plus the dynamic master tab.
2. A brief note (or on-sheet instructions) describing how to add future data so the merge continues to work.
Please keep the solution clean, reliable, and easy for a non-technical user to maintain.
I will be paying 600 RS
• each original file sits in its own clearly-named tab, untouched except for formatting consistency, and
• a fifth tab automatically pulls the data from those source tabs, stitching everything together through the columns common to every sheet—Name, Company, amt, date, and email.
The combined tab must expand seamlessly as fresh rows are added to any of the source tabs throughout the year. I’m happy for you to tackle this with formulas, Power Query, or another repeatable method, as long as I can simply paste updated data into the individual tabs and see the master list refresh without extra clicks.
Deliverables
1. Finished Excel workbook with the four raw-data tabs plus the dynamic master tab.
2. A brief note (or on-sheet instructions) describing how to add future data so the merge continues to work.
Please keep the solution clean, reliable, and easy for a non-technical user to maintain.
I will be paying 600 RS