Create and Auto-Populate One Multi-Row Worksheet Using Three Worksheets As Inputs

It’s been about 20 years since retiring. Prior to that I programmed different flavors of Cobol, Clist, Assembler, Focus, dBase (I-III) and several dialects of Basic (Quick, Extended, TI-Basic, etc.), but I must say Visual Basic (VBA) is a new and confusing “animal” to and for me. Maybe it’s because I’ve aged a bit . With the previous in mind, here are my challenges:
1. I have already built an Inventory Workbook currently consisting of 4-tabs

a. Warehousing Keeps a running list of what I have on-hand
b. OrderBy Keeps a running list of who actually orders my product(s)
c. Ordering Keeps a running list of who my customers are, what they purchase, etc.
d. Pick-Pack-Fields is created from certain fields within each of the above worksheets so that a Word 2007 mail merge can be used to create print shipping labels for the ordered product on any given day.

2. So I’d like to be able to…

a. Automatically create a new Pick-Pack-Fields (shipping label) worksheet .xlsx external file by automatically populating fields, row-by-row in the shipping label worksheet populated from one Inventory Workbook made up of: the Warehousing, OrderedBy and Ordering worksheets.
b. Automatically create each shipping label .xlsx file with a unique identifier such as:
Pick-Pack-Fields(yymmdd) – e.g. Pick-Pack-Fields(130814) while the next day’s output file would be Pick-Pack-Fields(130815), and so on…
c. Automatically run the Word 2007 Mail Merge from within Excel 2007 using the shipping form I’ve already created in Word and using only the Pick-Pack-Fields(yymmdd) file I choose to run, to prevent redundant shipping label prints, wasted time, toner and paper.

Since c.8/1/2013, I have tried several techniques no avail. Only manual intervention works for creation of the Pick-Pack-Fields (shipping labels) in Excel 2007 to be passed to the Word 2007 mail merge process. The mail merge using the Pick-Pack-Fields works fine. It’s just tedium ad infinitum.
Kindly help my understanding!
---Thanking You In Advance For You and Your Assistance, EWBJ

Hi..

Points a) and B) seem pretty straight forward..

For point c).. Other than Mail Merge.. you could use the "BookMark" method or the "Word Form Fields" methods to populate your Word doc from Excel..

Can you upload your Word doc(shipping form) please..