print multiple pdf's

i have a list of mulitple pdf fielnames that i am pulling from a db.

is it possible to combine them and have a button that will open all the files in one document?

Yes it is though you will most likly need to use a thirdparty PDF component to read in the PDF files and output a single file.
I use ABCpdf from webSupergoo:
http://www.websupergoo.com/products.htm#pd

In fact I've just done this very thing for one of my clients...