I've searched but haven't found the answer I need.

I use a macro to read a list of names, fill in a template and produce a sheet per name (timesheets). So 25 names give me 25 timesheets. Initially I printed each sheet but now I want to create a single pdf file with the 25 sheets in it. All I've been able to come up with so far is 25 pdf's.

Any ideas?

Thanks for the help...ptm