Is it possible to create a duplicate of a worksheet which is also dynamic, i.e. when one the master worksheet is updated, the changes propogate to the duplicate worksheet?

I know its possible to do it using vlookup but trying to avoid that path if possible as it could get extremely messy.

Thanks in advance.