data_you_need = pd.DataFrame()
for infile in glob.glob('*.xlsx'):
    data = pandas.read_excel(infile)
data_you_need = data_you_need.append(data, ignore_index=True)
Appending pandas dataframes generated in a for loop