Populate data from one main sheet to multiple sheets

Hi jeffreybrown,

I have an attached an example spreadsheet. I also sent a PM to Jerry to see if he had any insight on how to make a formula work with this, and he requested that I create a new post in the General section and attach a spreadsheet and he would respond. Here's the link to that: http://www.excelforum.com/excel-gene...32#post3063832

Let me know if you can figure out anything for live updating. Once again, I really appreciate all of your help.

Thanks!