I am trying to reference the current tab name in a formula. I am trying to
get a running total across several different sheets, but here is the catch,
those sheets have not been created yet. I have a template for a daily report
that a person will copy sheet over and over until project done. I want the
formula for the running total to reference the tab name so as copied it will
update this formula. Here is my formula =SUM(Day1:Day2!L20) Day1 and Day2
being the sheets, Day2 needs to be a general reference to current sheet
somehow but I can't figure it out