Copying Excel content to Word using drop-down list

Hi everyone!

I would like to incorporate a VBA script that does the following:

1. Create a new Word file
2. Select the first item from the drop-down list in Cell A52 Sheet2 (the drop-down item that is on top of the list)
3. Copy the first page of Sheet2 into the Word file as a picture
4. Select the next item on the drop-down list in Cell A52 on Sheet2
5. Copy the first page of Sheet 2 into the Word file as a picture, following the previous pasted picture
6. Repeat step 4. and 5. until a blank item is encountered in the drop-down list (These are present, because I want the drop-down-list to incorporate future input from the array into Sheet1)

Is it possible to do this with VBA? I can't find anything on using VBA to manipulate drop-down lists.

Thank you in advance for trying to help!

Cheers!