VBA Script Produce Batch Documents in Excel

VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template NOTE "Outline formatting would not paste into Freelancer Table" Need this weekend. • Availability- Must be Immediate. o We have to turn in documents for a job we completed by Sunday afternoon • Overview o VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template o Need for the current Project  So other requirements for the VBA that would generally be needed can be skipped • Such as pulling in Job info, client info, location info, subcontractor info, etc… • Rough Draft Structure (can be changed) o SOS Sheets- Producing multiple SOS (sign-out Sheets)  Template for all SOS is the same • Job Info, spot for manager to sign/print name and add store stamp, Legal e’s • Some SOS will need to be multiple pages  these SOS sheets will have items populated to it based on the date range selected in the ENTER SHEET • Table for SOS info- SOS #, Date range, Pg # • Table for Job Items populated within the date range • Table for a Daily summary for # of techs onsite and start and end times for that day • Table for the SOS File Name o ENTER SHEET  for entering the information to populate the Batch SOS Sheets • Table o We can enter a starting # for SOS o Job Part Info (for making file names for each SOS generated • Multiple Tables- for each SOS to be produced o Enter the start date o enter the end date o populates the items completed during the range  we can edit the list or add other items numbers to it