Challenges with un-structure excel data & email free text

Help
,
1

I’m working on a process automation and it’s currently under assessment phase. In this process I receive multiple excel files and each one unique in format and column names. and also, some of the data I need to fetch from email body and it won’t have any standard structure it’s a free text.

Here is some of the complexities that I found in this process:
Hidden Rows, Protected sheets, column names are not standard.

expectation is I need to create a Master Sheet from these different excel formats.
Please share ways and recommendations on this initiative.

2

Do each excel file are in different format @harsha_vardhan

3

Yes, each one is unique and columns also different.

4

Hi @harsha_vardhan

Like u need to create a master sheet out of these Excel files which are unique with respect to each other