I am creating a project tracking workbook in Excel 2003 for my work. I have
created a worksheet with project info including a project end date. I have
created a drop down list for all the months in the year so we can track these
projects. I am wanting to create a formula or somehow link those dates to
individual worksheets for each month.

For example, when the month of July is selected in a project it will
automatically send the info on that job to a seperate worksheet titled July.
I need a formula that knows which worksheet to send the project to based on
the date selected from the drop down list of months. I have created a
worksheet for every month in the same workbook as my Job Tracking worksheet.

Please send me help at