I hope I am doing this correctly, this is my first forum help request.

I am creating an Excel Spreadsheet that will be used analyze the performance of employees on a monthly basis.

I have 14 Worksheets. 1 Which we are calling the report card, 12 others for each month of the year and 1 for reference tables.

On the Report card sheet I have a drop down list that pulls data from a Lookup Table based on the name of the employee. Works like a champ. Is there any way to have excel pull data from a different worksheet based on a selection from another drop down list.

I.e. I want to be able to select employee JOE BLACK from drop down menu 1 and select the desired month of review (Different Worksheet for each month) from drop down menu 2. I then I want to auto populate my required fields on the report card from the worksheet specified in drop down menu 2 with data relative to the employee in drop down menu 1.

I hope this makes sense.

T