Is there a way to import or export Excel Data between 2 different workbooks?

E.G. Import from "File A" 'Sheet1' Column A, Row2 to "File B" 'Sheet1'
Column A, Row 2.

What I'd like to do ultimately is import data from 5 excel files into one.