Copying from One Sheet to Another but losing Format

[1LetterShor]

Hey guys, I work for an investment banking company and I have been tasked with using Pitchbook.com which basically creates Databases of companies that we use as potential clients, anyways I can create these excel sheets with Pitchbooks formatting although I want to transfer that data back to our Excel sheet with very different formatting. Is there any way to copy a full column or something and then paste back on our excel sheet WHILE keeping our formatting intact? Any help would be greatly appreciated

 

[Anthony47]

I guess that Copy from their sheet and Paste Special /Value to your sheet does what you are asking.
You can "copy" using Contr-c, then select the destination beginning cell and start Paste Special using the combination Contr-Alt-V

Or did I miss the point?