Mirroring One Tab to Another, But Not Vice Versa

Good Morning All,

I'll try and be as TL:DR as possible. I am entering the ever-dreaded income tax season. I am also the only person in our office under the age of 60. Needless to say, my one partner cannot stand Excel, which is unfortunate because I live on it. One reason he doesn't like it is because I have all kinds of formulae calculating how many returns I need to do per day to finish by a certain date, and several other similar computations that keep me on track, in control, and therefore less stressed. He wants to phase Excel out altogether.

My (secretive) compromise is to remove all of the formulae that are really just for me anyway and "dumb" the spreadsheet down to just the client name and the date it was received. I would, however, (and here comes the secretive part) like to have a separate tab that retains all of my formulae but pulls from the "dumbed" down list so I don't have to enter client names and dates received twice. Is there a way to mirror another tab where one has only client name and date but my other tab has a bunch of my original formulae on it? I know I can = another tab, but the problem is I sort returns alphabetically, by which ones are complete vs. not, by which ones got extensions, etc. so it's not just a straight down list. It constantly gets re-filtered.

Any insight would be great. I can probably mess with it and just do =$ calculations, but if there's an easier way, I'd love to hear about it. Also, the Excel nerd in me loves learning new things anyway, even if I can do it my own way.

Thanks!