merge multiple excel files with multiple worksheets into a single dataframe

df = pd.concat(pd.read_excel(workbook_url, sheet_name=None), ignore_index=True)

Here is what the above code is Doing:
1. We’re using the pd.concat() function to combine all the sheets in the Excel file into one DataFrame.
2. We’re using the pd.read_excel() function to read the Excel file.
3. We’re using the sheet_name parameter to specify that we want to read all the sheets in the Excel file.
4. We’re using the ignore_index parameter to make sure that the index values are reset in the combined DataFrame.