How to make data source for pivot table always be the activesheet?

[Bee Cee]

I have a file that is updated daily (each new day is a different tab) on which I've created a pivot table to summarize the data on that particular sheet. I would like to always designate the data location to be the active sheet, since nothing changes. Can anyone help me understand how to do this? Thank you!

 

[Bee Cee]

Thank you for sticking with this! It works, though I think the issue is that I'm on a Mac. I previously had a Dell and Excel is much friendlier in Windows. Thank you again for your input!