Excel Data Import with Power Query

I need to import data from an Excel spreadsheet with multiple sheets into a data range using Power Query. The sheets have different structures and contain mixed data types.

Requirements:
- Use Power Query to import data
- Handle multiple sheets with varying structures
- Support for mixed data types (text, numeric, etc.)

Ideal Skills:
- Proficiency in Power Query
- Strong Excel skills
- Experience with data transformation and import tasks

Please share your experience and approach.