transferring data from one excel file to another

I am trying to transfer some data from one workbook to another workbook….. with different formats…. I want a quicker way of doing it rather than copy and pasting all the way through..probably a macro that will be ablet to do this….