How to merge Excel Sheets Vertically?

This can be achieved in Pandas using the concat() function. The data frames generated from the read_excel() function are added as a list to the concat() function:

import pandas as pd

df = pd.read_excel('file-2.xlsx')
df1 = pd.read_excel('file-3.xlsx')
df2 = pd.read_excel('file-4.xlsx')
df3 = pd.read_excel('file-5.xlsx')

df_combined = pd.concat([df, df1, df2, df3])
df_combined.to_excel('combined_files.xlsx')

Then finally use to_excel() function to generate the new combined Excel file.