Been trying to work on a macro. Seems quite self explainatory from the pic. Have partially got a part of it to work. Here's what I intend to do:-
1. Copy all sheet names from folder path mentioned in A1
2. Open all the Workbooks in the source folder in Hidden mode.
Thanks in advance