for filename in os.listdir(path):
    if filename.startswith("PB orders"):
        full_path = os.path.join(path, filename)
        month = pd.read_excel(full_path, sheet_name="Raw data ", engine="pyxlsb")
        month = month[month['Sales Manager'] == 'MCLEAN, COLM']
        month=month.drop(month.columns[[10]], axis=1)
        filename, extension = os.path.splitext(filename)
        line = filename + '.csv'
        month.to_csv (path + line, index = None, header=True)