One Formula Links entire Sheet

[BeerBeer101]

I have a sheet that has many tabs, and teach week i send out SELECT tabs to reps. anytime there is a change to the sheet, i then have to re-save the individual rep sheets, hide tabs they are not supposed to see and password the structure of the sheet... i figure - there has to be another way...

is there a formula - in A1 of blank sheet that will copy the entire contents of another workbooks sheet in there. if it can take all formatting and conditional formatting - even better - but i can paste the formatting just as easy.

i know there has to be a way - and this is the place to find it!

thanks!

 

[Joe4]

Since you are using Excel 365, take a look at the new FILTER function (not to be confused with the old Filter functionality).
It is a spill function, so one single formula can return multiple columns and rows of data.
See: FILTER function - Microsoft Support