Hi Guys,

sorry if this doesn't make sense, i'm struggling to explain what i'm after.

Is there a formula to print a section of workbook along side the set print area if it is referenced in a cell? and also print it in order, i.e. following the page it was referenced on.

e.g:
If cell sheet 1, cell A1 contains a ref (e.g:1465) and A2 the word "multi" and sheet 2, A1:D5 contains a table with the ref in A1 as its title. (there are several tables on sheet 2)
The set print area is sheet 1 and it has many references.
Sheet 2 contains many tables to be referenced and printed along with sheet 1.

We send off the main page to customers but need both pages printing to see what we need to send. Could i print the table on a page following the page it was referenced on so as to avoid tedious re-arranging after printing? Due to the amount of references this often becomes a job in its self and takes up a fair bit of time to sort.

If there is a genius out there with a solution i would be so grateful, i don't seem to be able to find anything on Google.

Many Thanks
Sean