Trying to use drop down boxes to apply data

Hello. I am trying to draw data using drop down boxes to create sheets that I can print. I am going to do my best but please ask questions if I am not making sense.

I'd like a series of drop down boxes. I would like each drop down to have different option sets and depending on the option I want it to create data or a picture in a specified area on a separate sheet that I can print.

As an example:

Drop down 1: I'd like options A1, A2, A3, A4, A5. I'd like each of the options in the drop down to generate a different piece of information on sheet 2 in a specified area.

Drop down 2: I'd like options B1, B2, B3, B4, B5. Those options should all be different from the A and generate the info onto a different section of sheet 2.

Is this possible in excel or any other program?