Hi,
Basically, we run a number of training courses every week. The trainers save the excel file in the respective folder in a SharePoint document library.
Inside each folder, there is an excel workbook with multiple tabs which the trainers use to assess the trainees (see attached).
Is there a way to automatically send data froma multiple sheets workbook to another workbook?
I basically want to use the data to generate a live Power BI Dashboard that gets updated whenever a new course is completed.
Thank you.

Report
All responses (
Answers (