I have two worksheets. One for accounts that are active or are pending account. The other worksheet is for inactive, cancelled or rejected accounts. (I use this file to keep account status up to date and for different reports on separate worksheets.)

i need a way to create a new separate file with just the active and inactive sheet I have two files that list all our contract sales so we have columns titles:
Date booked
acct status
customer name
acct number
Contract start and end date
contact info
etc

I have two worksheets. One for accounts that are active or are pending account. The other worksheet is for inactive, cancelled or rejected accounts. (I use this file to keep account status up to date and for different reports on separate
worksheets.)

i need a way to create a new separate file with just the active and inactive sheet described above but have them linked so that once a contract status is updated it automatically updates on this new file as well. Id also like to move it to the inactive spreadsheet if the account went from active to inactive.

The second file would be used to keep track of customers monthly usage and seeing since contracts could be up to 5 years its just too much information for one sheet so if like them to be two separate files but i dont want to have to make updates to our accounts on two separate files.

I hope I explain it enough but if you need any clarifications please let me know. Any help would be greatly appreciated.