Well, if you just want to match the format of the source information,
highlight it on your source page, then Copy. Now on your summary sheet, do a
Paste Special: Formats. The Paste Special option is on the right-click menu
or the Edit menu.

"PMach" wrote:

I just figured out how to link different sheet and files. I'm using a
summary page to keep track of totals from different workbooks. However, once
it goes into the summary sheet, the formatting is gone. I can't figure out
how to format the linked information. Can you help me out with that? Thank
you.