I want to create a tool that is able to extract a specific sheet, e.g. "corporate", from a number of different Excel files, and consolidate it into one Excel file. Currently I am uploading the Excels from a folder on my local Desktop.
Solved! Go to Solution.
@PassION_es updated workflow attached
thank you @binuacs