You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

How to Perform Multiple Queries on an Excel Spreadsheet. Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server.