How do I merge info from different tabs. Each tab has 100's of client names
in it and the info needs to identify the client and then fill in certain
cells with the appropriate info

thanks
--
Ted