aks87 0 Newbie Poster

hi...im trying to summarize a number of excel workbooks into a single workbook for analysis.
I am having problems with selecting specific cells. The select statement is not working.
Is there anyway by which cells from different excel workbooks can be merged into a single workbook?