I hava problem in Excel Vba Macro, I have macro to enter the data throught
from in excel sheet after entering all the data she will be closed and end the
macro..now what I want is.....

I want to prepare a summary sheet of whole sheets throught Excel Vba Macro so
give me logic for coding also prepare sheet of multiple file multiple sheet....