# encoding: utf-8
import os
import pandas as pd

file_path = r"*\data\tmp"

new_df = []

for beg_path, sec_dir_path, files in os.walk(file_path):
    for excel_file in files:
        file_full_path = os.path.join(beg_path, excel_file)
        df = pd.read_excel(file_full_path)
        new_df.append(df)

dfs = pd.concat(new_df)

dfs.to_excel(r'*\sales.xlsx', index=False)