I have a work book that list all actives projects for our PM's in one work book. The work book contains some date that is extracted from the financial systems, as well as manually entered projects. We have multiple PM's and i would like to extract all data pertaining to the a particular PM into a separate work book. In addition I would like the formula's to copy with it as well.

I have attached a copy of such a file.