Write a VBA Script that populates a PDF form

I have spent a lot of time trying to write this scope as detailed as possible. Please read and understand it thoroughly before bidding the job. If you understand it please Chat with me to clarify any questions. If you messenger me and have not reviewed the attachments, you will not be considered. I need the project completed for Monday. I will only be available until 5:30 EST today to assist you instantly. After that I will be slow to respond until Monday, where I will be available for immediate assistance. Once completed, I will have several more projects basically the same. I will want to replace all of the WS that begin with “SO_” with the same type of script. I look forward to working with you. I have attached 2 Files. The one named Pricing V100 has many worksheets. The worksheet I need replaced is the “SO_Eagle”. Instead I need a script that will populate a PDF form. Currently I click the “Fill” button on the “SO_Eagle” WS and it runs the “SO_Eagle_Fill” script. The problem is that I can no longer use that WS form I created in Excel. I must use the PDF that they have provided (See Attached PDF Form named “ORDER FORM 5.0”). The scope of work for this project is as follows. 1. Create a script that when executed, will populate the PDF Form named “ORDER FORM 5.0”. 2. The logic on how to obtain the data to populate the fields can be located in the script “SO_Eagle_Fill” 3. The “ORDER FORM 5.0” form will always be located in the following directory, a. G:\My Drive\001Pricing\Eagle\Purchase Orders\G:\My Drive\001Pricing\Eagle\Purchase Orders. 4. Once populated the PDF would be saved (remaining editable) to the same directory that the Workbook is currently saved in. a. For example. If the WB Currently is saved as G:\My Drive\001Customers\6 Quotes\Example Client. It would save it there. 5. Create a save naming scheme. a. The PDF should be named using the PDF the current Workbook name and append “Eagle Order” (WB name can be located in ‘Contract AD3’). b. For example, the current WB name is Example Client, so the PDF would be named Pricing Example Client Eagle Order.pdf. Thank You for your time and consideration.