Jacqui
Several worksheets would certainly be complicated to coordinate. Have you thought of running one worksheet but organising/filtering (and then presenting) your data using pivot tables?
Happy to discuss if you have the time/interest!
Nick Stiven