I send 3 different work books to 3 people via email. They send them back with their information in 1 worksheet. I want to link their different worksheets into MY summary workbook. My summary workbook contains one sheet for each of their work book, work sheet. I need to copy over the information and have tired linking, but I lose the formatting. If I try with formatting it gives me zeros in all the spaces. If there is another way to do this please help.

Thank you
DW