I have office 2007, if that helps.

I need to incorporate info from the same cells within each workbook into the cells of one workbook. Specifically, the same cells from C7 and C11 from each workbook to align sequentially down a column in the main workbook. What is the quickest way to do this without doing it manually?