Drop down to automate form printing.

[mattlehman84]

I am currently working on an excel workbook that is set up so information filled on the first worksheet filters to different areas in the following three worksheets. I have a dropbox selection that selects from 40 different selections. This is a police department and these are charge forms. The first page in the workbook is the arrest report. For Example: While filling out the arrest report the offender may have been arrested for (Theft), which would be selected in the drop down box. I have 40 different coresponding microsoft word documents for each charge like (Theft). I would like to be able to have it setup so when I select the charge, the form automatically fills the info from the arrest report into the Word charge sheet. and then automatically prints the sheet.

IS THIS POSSIBLE????