I'm a newbie so please forgive me if this topic has been posted. I
conducted a search, but didn't find a related topic.

I have created a way of tracking my time and pay for multiple jobs
(don't ask). In a nut shell, I use a seperate excel file (workbook) for
each month. Then I have a seperate worksheet within each file that
pretains to work done in a particular week. The names of the worksheets
are based on the the Sunday date of that week, ex. the worksheet that
pretains to January 8, 2006 thus is named 01082006. In addition, each
file has a worksheet that sums everything that happened in the weeks of
that month.

Therefore, FEB06.xls ( the file for February '06) has six worksheets.
They are named Total, 02012006, 02052006, 02122006, 02192006, 02262006.
I would like to write a function that would allow me to call
(Get/Insert/Whatever???) the name of one of the worksheets into a cell,
then a function that would allow me to call a different worksheet name
into a different cell.

As a result, the function in A14 would return 02012006, A15 would
return 02052006, etc....

Any help would be greatly appreciated.

Thanks

Omni