Print + autochange info contained
 

I am rubbish at programming but thought I should be able to have a go at this.

I have a workbook with 3 worksheets containing various charts. I have a
drop down box in which I can change the department (31 of them) which then
changes the info in the charts. Is it possible to create a button that I can
click that will print all 3 pages for dept 1, then dept 2, then dept 3 etc
without having to do it manually?

Kate