I have 21 Excel file. Each of them has 25-40 sheets. Each sheet has the same structure.
How to make automation for this set of data? How to take Sheet and File name in Field?
I think you want to create a wildcard union.
Hope this answers your question!
Retrieving data ...