Hello. If I want to consolidate worksheets and load to connection on 30 sheets let's say. Is there a way to get ALL tables in each sheet to load to connection (1 for each table) without having to do manually do it. In this case, a macro is almost easier than the power query function.
Bookmarks