I need a daily sales sheet to pull from monthly figures sheet

I am a sales manager a retail store and want a daily sales sheet that can
pull my daily sales plan and yestedays totals from another sheet in my
workbook, as well as pull the scheduled associate shifts for that day. I want
to know if there is a way for one sheet to automatically change days and
import the day's info. Currently i have a seperate sheet for each day of the
month.
I am using excel 2003 at work and excel 2002 at home.

Try this example out. I created 2 user-defined functions using VBA. The first one is called "getsales". To use it, type "=getsales(x)", where x is the reference to the date you want to look up. To have this date automatically refresh, have the cell designated by "x" above contain the formula "=today()". This pulls info directly from cell B3 on whatever tab you select using "x".

The second formula is "=getinfo(x,y)", where x is the reference to the date and y is the reference to where the info is on one of the daily tabs. Since "x" will refresh automatically with the "=today()" formula, this formula will also automatically refresh. It works by grabbing the cell reference from "y" and applying to the worksheet from "x".

Note that all daily tabs will need to be set up identically for this to work. If you need them to be different, it will require a bit more programming in VBA.

Sorry if this is confusing.