I have a rental property and I want to create a series of spreadsheets that are linked and will automatically update one another. I will have my staff use one spreadsheet to record daily costs, income, various statistics and such and I will have a master spread sheet for all other aspects (income, tracking services, staff salaries) and more.
I already have the spread sheets I want to use, but I would like to adjust them a bit and make them integrated. They are not correctly laid out. Therefore, I need someone with skill and experience to set them up correctly as well as to add functions.
This would include making custom categories so that when a staff enters something he/she must give it a category which then is "plugged into" the master spread sheet.
In the end, all fields will update...how much we spent on meals, fuel... how much we made from guest services, transport...how much we pay in tax..etc..