I was told that I could add sheets in a way that would automatically be included in a formula on the 1st sheet to recap all of the other sheets. We track jobs daily on sheets which all match exactly. We then add up the same total cell in each sheet to a master invoice - sheet 1. Before I do this manually I thought I'd put it out there in case there is a way to add a sheet and not have to change every formula on the master to include the new sheets. I've never heard of this and have used excel a lot over the years with some extensive worksheets. Although I've not used a worksheet like this client has set up so it's certainly possible that what I'm asking about is possible!