I'm familliar with the following process to create links and transfer data to
other tabs in on active spreadsheet:

Hit the = key in the cell (on the tab) that you want the information to
appear in.
Go to the tab and cell you want to transfer the relevant data from
Hit the ENTER key
€œLink€� created and changes to the cell containing the original value or
formula will affect the cell to which its been brought forward.

However, I'm attempting to clean up my spreadsheet for better clarity and
ease of reading.

I would like to do the following:

Continue to have the "Master Tab" contain all of the relevant client
information, and flags (identifying when I have to follow certain
procedures).

Create a unique tab (on the same spreadhseet) for all statistical tracking
(e.g. number of client's referred to treatment, number of client's seen
during a specific month or year, etc).

I didn't know if there was a formula I could use which would allow me to do
this outside of the standard "linking" process above. I still need to pull my
various formulas from the "Master Tab" (e.g. Countif, array's, etc) to create
the needed "stats", but I'd like to keep this "statistical Information" off
of the Master Tab itself. Thus, if the formulas developed on "Tab 2" (for
example) could grab the needed information from the Master Tab (Tab 1) my
desired outcome would be accomplished.

Thanks for any help!

Dan