How do I get data from one Excel spreadsheet pulled into another?

I'm trying to get data pulled from one excel spreadsheet into another. I'm not necessarily looking for the exact details but topics and title searches I should be reading up on.How do I get data from one Excel spreadsheet pulled into another?
To reference another workbook you use the form





[WorkbookName.xls]WorksheetName!RangeHow do I get data from one Excel spreadsheet pulled into another?
access