Help with basic copying and pasting data to a summary sheet

i need an excel vba script

to ask the user to open a workbook by choosing the folder and file

copy specific cells in the various worksheets in that workbook (eg "sheet1 a1 to variable firstname", "sheet2 b2 to variable surname" "sheet3 c3 to variable age" and close the workbook

open a seperate workbook in a specific location (eg c:\results) and name the it summary

copy the previously variables to the new summary sheet under the headers of firstname surname and age

drop to the next line and ask if another workbook is required, if so, bring up the file dialogue box again open the specified workbook copy the new data (it will be in the same locations) underneath the previous data

continue until the answer is no to another workbook requiring to be opened

save the "summary" workbook and exit.

i also need another seperate code to do the same but if it could automatically get the data from a specific directory/folder (eg all files beginning nis???)instead of having to individually specify the files

the file the user is opening brings up the question do you want to open as read only and when closing a reminder to save any changes to the original file, i dont want to change anything and obviously dont want to save so can these message boxes not appear?

Thanks in advance this would be a life saver :-)

hi there, yes once the summary workbook is completed (user doesnt require anymore workbooks added to the summary) everything closes
on the workbook the user picks to open it will copy various cells on various sheets in that workbook and stick them all on one row on the seperate summay workbook, then drop down onto the next row for the next user required workbook (a simple loop)
to stop from processing already processed books (in the manual example the user picks the files so no problem, in the automatic example maybe copy fthe files in the folder to the sheet and drop down each cell/filename till the end is reached?)

The initial scenario is the basic version and with the code i could just increase the cells required and locations/sheets to fit whats required.

Hope that explains a bit better

Thanks a lot