Generate pdf or word files of a receipt from different suppliers

Hi everyone,

Attached is a workbook containing 3 tabs. The first one cotains a receipt, the second and third contain the details usually printed on the receipt. Now I have 10 suppliers(I only included 2 in my workbook) and I want to be able to generate 10 receipts (in a pdf, word or excel format ) for the 10 suppliers without creating extra sheets/tabs in my workbook. Can someone guide me on how to write VBA to do that?

this is the attached

I posted the same problem on the Access forum:
http://www.access-programmers.co.uk/...d.php?t=125361

Having this in access is also helpful

access help was not useful