How to load a particular sheet from different Excel File??

[soha1902]

Hi All,

I am having 10 excel file 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.

(All are dummy url only)

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......