Linked Excel Daily Sheets

Job ID: 39708042

Budget: $30 – $250 USD

I’ve already built a “Master Input” workbook and a few sample daily sheets, but I need a specialist to finish the job at scale. Each target workbook must contain 365 identical daily tabs that pull data from the Master file strictly by date. All routine formulas are already in place; the task is to replicate those sheets accurately, link every cell to the correct dated range in the Master, and test that the information flows instantly whenever I update the Master.

Deliverables
• Three fully linked workbooks (or more if we agree) each with 365 populated daily sheets
• Date-based links verified and working end-to-end
• My original formulas preserved and extended across every sheet
• A brief note explaining any helper ranges, named ranges, Power Query steps, or VBA you add so I can maintain the system later

Acceptance criteria
Updates typed into the Master on, say, 15-Aug must appear in every counterpart 15-Aug sheet within the linked files without manual refresh. Zero broken references, #REF errors, or mismatched rows.

If you’re comfortable automating replication via VBA or another rapid-build method inside Excel, this will be quick work; if you prefer manual duplication, that’s fine too as long as the links remain solid.

Let me know your approach and estimated turnaround so we can get this wrapped up.