Excel Sheet Consolidation & Organization

I have around 70-80 tabs in excel that have projects and some other tabs that it’s not projects and I don’t need them . If I can give you list of tabs that I need to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ?

The main tasks required are:
- Merge the selected tabs into one sheet
- Organize the combined data by project name
- Present the data in alphabetical order

The person ideal for this job should have:
- Extensive knowledge in Excel handling and formulas
- Proven experience in data organization and Excel management
- Ability to strictly follow given instructions
- Proficiency in English for clear communication
- Attention to detail as precision is key in this project

While this project is relatively straightforward, it requires clear comprehension of the dataset and careful execution. I am looking forward to working seamlessly with you and get this project done efficiently.