Excel Formula

What formula would work if I wanted to copy detailed from spreadsheets in a book identified by date and automatically copy the detail from specific cells on each dated spreadsheet into one column in a master spreadsheet?