Formula referring to Tab Name

[tiinag]

Hi,
I need to create a dynamic formula that refers to the tab name which will change depening on the date/month that file is created for. Is there functionality in Excel that can have a formula refer to the tab-name that corresponds with a column header. I'll have daily tabs and daily columns for each month. Basically the summary tab needs to be able to pick up values from each daily tab and populate the corresponding day's column.
Thanks,
Tiina

 

[ExcelChampion]

take a look at the INDIRECT function in the help files.

HTH!

 

[tiinag]

Hi, I've been reading through the Indirect function questions but I think they are different as they're mostly looking for data in a different workbook, my data will all be in the same workbook. I'm looking to do a sumif formula. Can you guide me to a previous question that is similar to mine? Thanks