excel vba macros

hello, I am wondering what the best/easiest way to do this is. I have 2 worksheets from a workbook called Annual Budget that I want to copy essentially. I grouped graphs from multiple spreadsheets into one tab, and want these other 2 worksheets from Annual Budget to be 2 other separate tabs to create a new workbook. I tried to do a ‘move or copy worksheet’ but the information didn’t automatically update on the new sheet after it was entered on the original. Do only graphs do this then? This new workbook I am creating is for reporting purposes only, to gather the info the managers need more efficiently for meetings. Basically I want the exact same page, but I just want it displayed on another workbook too. Any way for this to happen? thanks very much