Replicating the data on other worksheets is fairly straightforward, but you haven't given anywhere enough information for that. We'd need to know what sheet the data are being transferred from, which cells the data (including the 'association' data) are in, plus the corresponding information about each of the destination sheets.

I'd also have to question why you're trying to replicate the data on four worksheets, instead of having all the data on a single worksheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]