Master extractor from zip file to excel

I have excel sheet in which i have to feed data everytime when the zip files of my nodal offices comes.

So how do i do that:

I save all the zip file of nodal offices into the same folder then open the zip files one by one and then open my req report in those files and then copy the req data to my sheet

what i want is:

I paste all my zip files in the same folder where my excel sheet is saved then a macro should be such which merge all the zip files in that folder and create a master zip file havin the records of all the zip files

then macro code ask what to serch in zip file :i put report name and under report which field

and the corespondinh data of that field may come directly on my excel sheet

i knw req is complex but i still have hopes for it

Is it possible to merge zip files and then import all the text files in the final zipped file to a excel sheet

Plz help......by a vba

Any body plz try