Power Query Help

[sur]

Hello Team,

I have a individual workbooks (each workbook share 3 sheets with same Sheet name, column names) in a shared folder/Onedrive.

Requirement is to prepare the master workbook ( with same sheet name, column name ) with changes made in the individual workbooks should be reflected in the master workbook & then connect the master workbook to PowerBI.

Thanks,
Suresh H