excel automation using python and gui

The purpose of the project is to automate the planning for the cleaning teams of several apartments. The program has to be able to create a planning from different excel sheets /csv files. Different excel sheets will be provided. These sheets, files contain bookings from [login to view URL] and booking.com. The sheets contain data regarding the booking data, by whom the property has been booked, check in, check out date etc. We need to be able to look for the different files on the computer, put them in and merge them together automatically. After this is accomplished we need to clean up the data. Some properties will be registered in different files but on a slightly different name,(by using multiple accounts the user has more exposure on airbnb and [login to view URL]).So when we will merge the files, we will need to have a clear overview of all the properties which are booked per day. We do require a simple GUI. One field where we can browse for the different excel file which we want to aggregate together, 1 button to process this file and the possibility to extract the planning.