I have created a spreadsheet with about 6 tabs. Often data on tab 1worksheet
is found again on tab 2,3,5,6. I would like this data to be auto filled so
that changes only need to be made on the first tab. the change will then be
updated to the other corresponding cells with the new data without having to
enter it onto each tab.
The other tabs will then be protected so the value can only be changed on
the first tab.
Thank you
Martin