open files in folder and copy sheets to new workbook

Hi,

I'm trying to create a macro that will open excel files in a specified folder and then Copy a sheet named Summary to a consolidated workbook.
all of the excel files in the folder will have a sheet named "summary".

also, when it copies the sheet "Summary" it can rename the sheet tab in the consolidated book to the name located in cell A1 of the summary sheet.

example:

folder path: C:\my documents\
file 1: testfile1.xls
file 2: testfile2.xls
.
.
.
testfile1.xls contains a sheet called summary and in cell a1 display "testfile1"

copy sheet "summary" to consolidated workbook

Consolidated workbook will contain two sheets. 1 from testfile1 and the other from testfile2.

i hope this make sense.

i tried searching for other codes but could not come up with anything similar