Power Query Update Excel Files from Folder

Upload multiple files with multiple tabs into a single data source with Power Query.
www.thesmallma...

[@marchingideas298]

Exactly wht i was looking for

[@kebincui]

Excellent. Thanks for sharing

[@thesmallman]

My pleasure!!!!

[@nlopedebarrios]

Hi, great tutorial. However, I would like to load the data into an existing sheet, but the option is greyed out. What could it be?