As an afterthought, why do you need this type of layout, where the data is simply duplicated? I am wondering if there is a better way to address the big-picture problem that you are trying to solve by just using your master table at the top, or possibly by splitting each table onto a different worksheet. It all depends on how you need to use it.