New User - is my project idea feasible?

I have compiled a list with multiple columns in which one column will be changing every so often when updated. I have also taken this list and broken it down into smaller list and would like those other Sheets to have that column update in tandum with the original list.

I have done some research about the ADDRESS function, but I can't make sense out of any of it.

Any help would be appreciated.

There are numerous ways that we can do what you ask.

If you are pasting new data into the column however,

We will probably need to use a macro.

Come back with a sample spreadsheet.

And state your requirement as clearly as possible.