We are able to spit out the data into an excel file with multiple sheets, now we are trying for other way round where we want to parse all the data across multiple sheets and load into Pega.

You can try this link..https://community1.pega.com/community/pega-support/question/how-read-data-excel-sheet-if-it-has-two-tabs

Hi

Sheet names should match both in template and uploaded excel. Refer below URL for more details

https://community1.pega.com/community/pega-product-support/question/can-we-parse-excel-file-multiple-tabssheets

Thanks

Krishna