importing data from multiple worksheets into one table

Debbie57 Yes, you can do this by using Office Scripts and Power Automate. You can create a Flow that gets all the workbooks in a SharePoint folder. Then, using the Run Script action in the Excel Online Business connector, you can run an Office Script on each of those workbooks to get the specific data you need and add that data into a table in another sheet. Here is some documentation about Office Scripts as well as how to get started using Office Scripts and Power Automate. Let me know if you need any additional help!