Create Loop for Printing Reports

I have attached a workbook with a report and code [Test-1] assigned to a macro button called Print All. Right now the code enters a value in cell A3, hides and unhides selected rows based on values in column A, prints the report, then moves on to report #2 (in cell A3). It does this 347 times. I am hoping to create a loop that executes the hide/unhide/print, then replaces the value in cell A3 and repeats the hide/unhide/print without repeating all the code. Any/all suggestions would be greatly appreciated. - TJ