I have 1 workbook.
10 sheets in this workbook.
i created another sheet titled EVERYTHING.
In the EVERYTHING worksheet i have performed a copy/paste special link so that if i change something in the individual worksheets it will change on the EVERYTHING worksheet;however, i don't know how to make it work in the other direction.
Id like to put entries in the EVERYTHING worksheet and it will change the individual worksheets.
Also the EVERYTHING worksheet is a table(i dont know if that matters).


Thanks for your help everyone.