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.