How to load a sheet from multiple excel files??

[soha1902]

Hi All,

  I am having 10 excel files in one url. (In future it’ll increase or decrease)

  All excel files names are different but all having the same structure (Same sheet names and column names)

  All excel files having the 3 sheets like Sheet A, B, and C.

  I want to load Sheet B only from all excel files through one LOAD statement.

  Can anyone please suggest me how to do this???

  For example:

Following are 5 sheets and all are having 3 sheets like Sheet A, B, and C.
I want to load Sheet B only from all excel files through one LOAD statement.

1. https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_First.xlsm
2. https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Second.xlsm
3. https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Third.xlsm
4. https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fourth.xlsm
5. https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fifth.xlsm

Please help.......