How to read multiple excel files in a folder and multiple sheets in an excel file?

Hi,

I need to read multiple sheets of same format of an excel file and combine them into a single table.

Also I need to read multiple excel files of a folder and combine them.

Thanks