Macro to Copy and Paste Special Value to avoid Circular Reference

Hi all,

I am looking for help in creating a macro that will do the following:

For any sheet that contains a "," so in my case, any sheet with a person's name on it:

1. Do two VLOOKUPs that both use K1 as the lookup value, the table arrays A90:B126 and E90:F126, column index number 2 for both, and range lookup "FALSE" for both.
2. With the two cells that are returned, I'd like to copy, and then paste special, values.
3. If any of the sheets containing a "," do not have any data in the table arrays, i'd like for the macro to just go to the next sheet.

I have attached a sample workbook. If you have any questions or need more information please let me know.

Thanks,

Jordan