Data Consolidation from Multiple Sheets

Help me consolidate data from multiple sheets into one:

**Source Sheets:**
- Number of sheets: [count]
- Sheet naming pattern: [e.g., Jan, Feb, Mar or Region1, Region2]
- Same structure: [Yes/No - all sheets identical layout?]
- Column headers: [list key columns]

**Consolidation Type:**
- [ ] Stack all data (append rows)
- [ ] Summarize/aggregate (sum, average by category)
- [ ] Side-by-side comparison
- [ ] Create pivot from combined data

**Data Characteristics:**
- Rows per sheet: [approximate]
- Identifier column: [column that links data across sheets]
- Values to consolidate: [which columns/values to combine]

**Dynamic Requirements:**
- Sheets added frequently: [Yes/No]
- Data grows in source sheets: [Yes/No]
- Automatic refresh needed: [Yes/No]

**Current Challenges:**
- [What specific issues are you facing]

**Tools Available:**
- Power Query: [Yes/No]
- VBA allowed: [Yes/No]
- Excel version: [specify]

Please provide:
1. Recommended approach for my scenario
2. Power Query solution (if available)
3. Formula-based approach
4. 3D reference approach (if applicable)
5. INDIRECT for dynamic sheet references
6. Maintenance and refresh procedures