Excel Guest List

I need a Excel sheet for a Property where daily guest record are recorded including the check in and check out options. It should mention the total no of guest in certain rooms as well as from where they are from in the report. I need a different excelsheet where it reads the report section of the first excel and have option for breakfast lunch and dinner tick option to monitor who had those meal. This project has to be done in my computer via remote access. I already have a template for 1st excel sheet and just needs few modification so it can be customised according to my need. But second excel sheet needs to be created. Or I am open with any other options.