Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a report life would be good - can't be done. If I could do a sheet to sheet formula - this would help - can't be done. While creating a new sheet a cell link would automatically be created to a destination summary sheet - I don't think this can be done. I am trying to make this as seamless as possible for our end users. I have created many workarounds for other issues but this one has me stumped. Our management team wants to know how many projects we have open in each category.