loading multiple excel files where the names and the sheets are different

[0li5a3a]

If the names of the excel files are like below scenario?

Scenario:

Excel file name abc dsadsadsadasdas.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 saddsdnadnsabdasbnjknhd

Excel file name abc dsadsajdhsadhsadsajd.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 bbcscsbds

Excel file name abc dsadnasjdaskifh.xlsx

      this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 asacsasadsadas

Excel file name abc sdadsnadnsadasdasjnhdasn.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 ssda

Thanks in advance !

[sunny_talwar · Accepted solution]

So how is this question different from what you asked me on the other post?

Anyways, there is no way to wild card the sheet name (from what I have seen in the past).... you somehow need to supply the name somewhere....