I am looking for an option to load each sheet from an excel, no matter of naming or number.
Each month I am loading excel workbooks, with several sheets. Some month the excel consists 13, other month 15 sheets and some sheets may be missing one month and appearing the next month. The naming of columns is identical in each sheet. Nowadays I am checking manually, if each sheet has been loaded, but I would like to automate it. What is the workaround? I was trying through iteration, but didn’t work well. Thanks in advance!