VBA Developer Required to Consolidate Data

Job ID: 39117955

Budget: $10 – $30 USD

I'm looking for a VBA expert to help me consolidate data from over 21 tabs in a workbook into a single 'All-in-One' tab. The data in these tabs is purely numeric.

Key Requirements:
- Develop a VBA script to copy data from 21+ tabs into a single tab.
- Ensure the data is copied as values only, without any formatting or formulas.
- Create an "INDIRECT" formula to retrieve data from a different tab within the same workbook.
-The other tabs name have space in the name like " part 1 part 2 many space in name" this is just an example of tab name

Ideal Skills:
- Proficient in VBA programming
- Experience with Excel data consolidation
- Understanding of "INDIRECT" formulas in Excel

Please note, the data should be copied as values only.