Copy and Update data in 2nd workbook from 1st work book

Hi,

I have a work book 1 with all my business sales data. I want to make another workbook, which has exact same data from workbook 1. I want that happen automatically copied on work book 2 from work book 1. Also when I update data on workbook 1, my work book 2 data also updates.

my work book 1 has some formula work.

I want this way becuase I don't want to do copy and paste everytime. I frequently updates data on my work book 1.

And make sure it is 2 different workbooks, when you ppl help me.

I hope this understands you guys.

please let me know if you have any questions.

Thanks