Vba for Excel Automation

Hi.
We have an Excel file that I want to link and capture data.

Basically, we have this file called Master Production Schedule (MPS) whereby it shows all the Finished Goods (FG) that production department want to run on which date and at what qty and at which production line or at which machine. The qty can be in cartons or batches.

I have another file which shows the open Purchase Order (po) whereby it shows all the balance qty of a po and the planned delivery date for certain qty. We call this file as Order Tracking (OT).

We also have another file bom which shows what are the material needed and what is the qty needed to produce one batch or one carton of certain fg.

We have another file named Store which shows the stock figure as of today's date.

We want to have an Excel file (file A) whereby when we copy and paste the MPS to this file A, it will prompt with qty that we need to purchase, and it will define the delivery date and qty for a specific delivery date. It should take into consideration of the today's stock figure from Store file and any open PO qty before informing us the required qty for specific material's Item Code on a specific date. Basically, the required qty should take into consideration of standard packaging (round up to the nearest standard pack). FYI, all item code will be listed in file A as well

Please advise what is the cost for this project. Please send me quotation at chengee dot lim at qsrbrands dot com dot my.

I would like to schedule a Teams or Zoom meeting to explain more before you start the job.
Thank you.