VBA Code Help to SUM Cells Across Worksheets

[nhbartos]

Hi folks,

I am putting together an Exit Interview workbook and need a lot of help.

I have a summary tab which should total the same cells across multiple exit interview worksheets, as they are added.
I have one Exit Worksheet 1 tab, and more will be added as needed.

I have a macro button at the top of the summary which I need code for to insert a new Exit Interview tab at the end. I am not sure if you need a template to do this.

As new tabs are added, the names will be changed to the exiting staff names, and I need the added tab counts to automatically be added to the summary.

On Exit Worksheet 1, off to the right, in the gray area, I have the counts for this sheet. Each sheet will have the same if this is used as the template.

I am not sure if you need to use the counts in the gray area, or if you can use a vlookup or something similar in the Summary to pull the data directly from the cells themselves. All selections are via drop-down list.

I am not sure I made any sense, but I hope I did.

I tried using this formula to count the cells across worksheets, but it seems to only work on the existing worksheets when the formula was made. It doesn't automatically update to add additional tabs. =sum('*'!F

Here is the link to the file: https://drive.google.com/open?id=0B1W8cwZVnTmPVXB5ZHgyT1JVM2c

Vin

 

[=ODIN=]

I think this type of formula might work for you:

=SUM('start sheet:end sheet'!A1)

assuming you create a workbook and position a worksheet named "start sheet" as the most left hand tab, and another "end sheet" as the most right hand tab-- with some tabs in between, this formula will sum cell A1 from each tab positioned in between them (as well as them). If however a tab is not in the middle of them, it will not be included.