filter multiple tables on the same tab based on selection of a row from a table

[jdt102010]

I'm trying to get my data on a shorter control loop by juxtaposing filtered rows from three different worksheets on a single worksheet. Tabs are named ADG, ADS, KW. Tab ADG is the master data set. When I select a row from this table, I want the data on the other tables to filter according to the selection made. The KW table would be filtered pretty much the same way it is displayed (but only a few of the columns). The ADS table would be filtered as well, but unlike the KW table, the few columns I show, I would like them transposed vertically with spaces between the data rows. Finally, it would be great to have a controller or something to show only the data in the row selected from ADG. It is similar to doing a mail merge, but I don't want hundreds of sheets of merged static documents. I want to be able to move back and forth between the rows of the master data set. The separate worksheets are necessary because the data on these tabs is updated regularly. How should I construct this?