Power Query itself doesn't directly export data to multiple sheets within the same workbook. However, you have a few effective options to achieve this:

1. Close & Load:

This is the simplest method for a single output table.

* Steps:
1. In Power Query Editor, ensure your data is formatted as desired in the final table.
2. Click "Close & Load" in the Home tab.
3. Choose "To table" and select the destination cell in your worksheet where you want the data to appear.

2. Unpivot Other Columns (For Wide Data):

If your data is spread across multiple columns, you can unpivot it to create a single table.

* Steps:
1. In Power Query Editor, select the columns containing your desired data points.
2. Go to the "Transform" tab and choose "Unpivot Other Columns".
3. Select the "Value Column Name" (usually the header row) and choose "Close & Load" as in method 1.

3. Dynamic Arrays (For Excel 365):

This method leverages formulas to populate multiple sheets based on a single Power Query output.

* Steps (Example):
1. In Power Query, create a query that groups your data by a specific criteria (e.g., Region).
2. In your worksheet, enter a formula like `=FILTER(Table1[Data],Table1[Region]=A1)` where "Table1" is your Power Query output table name and "A1" contains your desired region filter.
3. Copy this formula down to other cells, replacing "A1" with your different filter criteria for each sheet.
4. Excel will dynamically populate each sheet based on the filter applied in the formula.

4. VBA Macro (For Advanced Users):

For complex scenarios, you can write a VBA macro to loop through your data and populate different sheets.

Choosing the Right Method:

* Close & Load: Suitable for a single output table.
* Unpivot Other Columns: Ideal for transforming wide data into a single table.
* Dynamic Arrays: Efficient for Excel 365 users who want to populate multiple sheets based on criteria.
* VBA Macro: Offers flexibility for complex scenarios but requires VBA knowledge.

Remember to consider the complexity of your data and desired outcome when choosing the most suitable method for exporting data from Power Query to different parts of your Excel workbook.