Excel Time-Material Invoice and Payroll Builder

I already track every hour worked and every material purchase via field tech daily sheets that my techs fill out each day. I want to then put the info into excel. i copy the daily sheets and turn them into the client when I invoice. I have been hand writing them because I had not had a computer at the job. I brought one of my old computers... window 7 outlook 2013 to the job. I’m semi-retired just doing the job for a few months because it’s an old client I have enjoyed working for over the years. I just built a simple excel sheet to track the techs hours, and trip charges and expenses. In doing that I have realized how much I have forgotten. I would like to use drop down menus to populate fields and v lookup/or better to populate invoices to the client with the techs info I choose with the company costs for the job. I can then add the company’s daily costs and summaries as need. It is a time and materials job. No bidding. In an Excel 2013 worksheet I need that same file to generate a clean, print-ready invoice sheet—still in Excel—without having to re-enter any data unless I choose to change some of it. I have a summery accounting sheet –which is a summary of the daily accounting sheets I turn in ith the summary accounting sheet- this acts as my invoice.. The daily accounting sheets are made from the field tech daily summary that is turned in from techs each day listing their personal expenses, 906 expenses I can charge for (like purchases and or Truck stock used and a scope of work summary. I ad 906 company expense to this. I turn in the FT daily summary sheets as well with my paperwork. NOTES- I invoice for 5 to 15 days at a time. It totals up each line. Then I may give a discount. The client can read the daily sheets for details or review the ft daily summary the each turn in for details. I may fill in some of the scope of work completed but I always don’t have time to… since I'm working in the field and don’t have office staff… Some details… The daily accounting sheets include. At the top there is a date field and a day field and the total for costs and labor. Costs include trip charges$ costs for trucks of my fields if I choose to pay them (generally when they have to drive over 45 min I get them trip charges… also daily I charge $85 for truck 1 Company box truck foul of tools as long we work and I'm not just doing paperwork. if I use my other truck for towing, material pick up, and so forth, I charge them $45 for truck 2…. Next expenses are totaled and 15 % added- expense are truck stock used – I will enter a number I feel is close to the truck used for the day. Purchases – list purchases the company makes and some description of some the items and the costs for each purchase. List techs expenses as a purchases sometimes I need to reimburse them sometimes I don’t because use my card or other reason Equipment – I charge a set fee for my dump trailer or other trailers. Tractor ½ day or full day, also if implements for my tractor. For other equipment I need to charge for I just come up with a rate Labor Column lists tech 1 then the hours they worked – then their rate – then the total for that tech for the day. The techs names are not listed it is a generic Tech 1 Tech 2 and so on. What I need from you: • Link the excel I’ve started to make- tracking the techs hour and costs from the techs daily summary  to track and create payroll to the techs for a set amount of days they work  create daily sheets in a format similar to the sheets the clients have already been receiving • I'm to import the techs labor and expenses as well as add the company expenses to these costs.  And then a summery accounting sheet totaling up the days I'm invoicing for  and able to add a discount if I choose • this sheet continuously builds and I don’t have to make a new each invoice o I just can put in a range and add info as need to create payroll and invoices for the dates needed. And I get a report for each that can be used as an invoice and a payroll…. o These reports can be “Saved as a PDF” if I ever need it or printed.  on the daily accounting sheets the client gets the details- client details, job description, an itemized list of time and materials, as I see fit, separate truck/trip charges and the 15 % upcharge for expenses. o Include formulas (or a simple macro, if easier) that keep subtotals and grand totals accurate even when I add or delete rows in the source sheet. o All numbers are rounded up. • I hoping When you’re done I should be able to open the workbook, type in the latest hours and purchases on the tracking sheet, add the companies daily details and print—or email—the finished invoice or make a payroll instantly. • A brief note explaining any formulas or code you add will be plenty for me to maintain it later. Thanks for taking the time to decipher my grammar and elementary style of requirements. I didn’t have AI clean it up or write so they would completely take us off course and make it sound better while taking us off course- ! I'm sure there will some back and forth … so the please include some extra time to get this right.