Mirror multiple cells (one row) in another worksheet

[quick_68]

Hello everyone,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a database of training records that we have done with ALL 600 of our employees.
I need to mirror individual rows in other sheets that are labeled with specific area. Also I say mirror instead of copy because I would like when I change the main sheet it changes that value in location sheet as well.<o></o>
<o></o>Top row = classes C to AV<o></o>
Columns A, B = First and last name<o></o>
The rest of the data is dates that the employee has completed the training. <o></o>
<o></o>
I am breaking these names down to location where the work in the plant. <o></o>
<o></o>
As for the second worksheet they will match via columns A-AV but differ in which row they were originally. <o></o>
Ex... John Doe in row 25 of all employees may be row 1 in plant C sheet<o></o>
<o></o>
I hope I have given a good enough description and haven’t confused anyone.... i sure feel that way <o></o>
<o></o>
Thanks! <o></o>

 

[quick_68]

I understand that if i put "=" in the location worksheet and click a single cell it will change it as well which is what i want, but there are a TON of cells a would have to do this to . . . 40,800 i believe. i dont have that kind of time
Thanks