I was wondering if there was a way to copy from the main sheet into -all-
tabs that are active (with data in them, etc) where I can go and delete them
in the lower tabs if I do not want them there.

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

This one came close but it requires a formula to be entered in the sub tabs
and if I want to delete them, it will also delete the formula, thus defeating
the purpose.

Am I being clear enough?