Multiple check boxes on Sheet 1 to populate a dropdown on Sheet 2 from a lists on Sheet 3

Greetings,

I am quite new to VBA and will take the time to introduce myself later on tonight officially, but have a question that has been befuddling me recently. I have three sheets in a workbook (Sheet 1, Sheet 2, and References). On Sheet 1 I have three check boxes (Option 1, Option 2, and Option 3), on Sheet 2 is a small little chart, and on Sheet 3 I have three lists. My end goal is to make it so that when I check Option 1 on Sheet 1, Cell A2 on Sheet 2 is populated by the List on Sheet 3 underneath Option 1 there. I have tried dependent dropdowns, but unless I am doing something wrong it won't let me call it from one sheet to another. I've tried searching the forums for an answer and have not had any luck so far. Any assistance is much appreciated and I have attached a dummy spreadsheet to help clarify my text above.

try the attached file
hope it is useful to you..

Regards
CA Mahaveer Somani

Looks and works great so far. Thanks!

Glad to help you dear

Hit the star button for user reputation....

Regards
CA Mahaveer Somani