I collect information from about 200 constituents using an excel ‘form’. Each file has a “Department Only” tab where we are trying to total some of the other tabs. I anticipate there could be up to ten tabs.
I would like to use a macro or VBA to place the potential name of each tab (below) in...