Customized Print Options

I have been trying for the last 4 hours to come up with a customized Macro for Printing, including reading more than 200 posts in here. So, I wonder if anyone can help on this matter.

I have a workbook with 4 worksheets. The first one is my datababse (no need to print it), the second and third one are reports (need to print) and the 4th one is dynamic report that has 18 different options and secenarios depending on the Area I specify on a Cell in BC3 (18 areas such BA, CA, CB, CC, etc.).

What I am trying to find is a macro that will allow me to transfer in sequential order my 2nd and 3rd sheet and any (whether 1 or 18) area report depending on a message box that asks to input the area.

I would appreciate very much anyone's input on this matter.

Oops forgot this part:

transfer in sequential order my 2nd and 3rd sheet and any (whether 1 or 18) area report depending on a message box that asks to input the area, to an Excel Workbook, and print the whole in pdf format (i.e, I would have the electronic excel of the printout and the pdf hardcopy).

Regards.

I wonder if someone can help on this matter.

Regards.

I attached a sample of what I am doing.
4 Workbooks: "Base"," Report 1", "Report 2" and the Dynamic one "Various"

I would appreciate someone's input on that matter.