I have a workbook that is volitile and I would like for a macro to look up
value j13 and copy each one onto a worksheet. I need it to be volitle so I
dont need to change it each time a new person is put on the database.

Any ideas would be great

Thanks

Greg