I need to create a duplicate workbook on a different shared drive...this duplicate workbook needs to be updated and current with the data entered on my original copy which is on a different shared drive.

To further explain...I have a workbook on my own personal drive. But they want it to be available on a different shared drive with the continually updated information that enter throughout the day. So when someone looks at the workbook on the shared drive, they see the same workbook that I have with all the updates and new info that I have entered at any given time.

How do I reference or link the 2 workbooks so that any info entered on my source workbook shows on the workbook on the shared drive?

A sample of the workbook is attached in case you need it...

THANKS in advance for any help!

Sample.xlsx