Macro Printing One Sheet with one change at a time
 

Basically I have one sheet that displays a table that changes every time I
pull down a different number. So right now I currently have a pull down that
numbers from 1 to 50, but only 1 to 27 give me 27 unique tables, with the
possiblility that 28 through 50 may do the same thing in the future.

So my first question is create a macro that will print all 27 tables even
though they are located one sheet and each table could possibly have more or
less rows then the others, but they all have the same amount of columns.

From there I think I'll be able to figure out how to adapt the Macro to the
situation where I have more then 27 tables.

Can anyone help?