It sounds like you're asking if someone could write a script for you.
Try this first:

In the summary  file:
Do you have the Visual Basic Toolbar open?
Try recording a macro.
then open  one of the other workbooks.
Copy one piece of data from that workbook  to your Summary.
Close the other workbook.
Stop recording.

Now look at your module in the VBA editor.
it will give you the code necessary to open and close  the other workbooks.
It will also show you cell  references.

If you'll post what THIS macro  looks like,
and tell me which cells you want to copy from the 2nd workbook
and where in the summary workbook they are to go,
I can help  you write a short script.

What you're asking is fairly simple.
The information  you've given is SEVERELY lacking.

give it a shot and see what you come up with.