I have a user that needs to use their own excel file to keep track of their budget because of the extra data that is need to support it. However, we have a master file that we need to get a few cells copied over to be able to create and run pivot tables off all the data. What is the best way to get their data into the master file? I will need to be able to have the master file to be able to add rows and new data is entered in the other file, is that possible too?

Thanks for any advice.