Excel Sheets Data Consolidation into Google Sheets

I need help compiling user data from multiple Excel Sheets and Word sheets (but mostly Excel) into one organized sheet. The final sheet should have different tabs for different groups.

Requirements:
- Consolidate user data from various sheets to one Google Sheet
- Organize data into a single sheet with multiple tabs
- There will be a general sheet containing the combined and a separate one for nect point
- Each tab should represent a different group

Ideal Skills and Experience:
- Proficient in Excel
- Proficiency in Google Sheets
- Proficiency in Data Analysis and charts
- Experience with data consolidation and organization
- Attention to detail to ensure accuracy
Hired Freelancer may be busy with the team for a year.