macro for excel task

Hi All,

I have a 100 + workbooks with seperate name...

i need to open each book and copy entire fields to a template and then calculate some metrics....

i have attached the template (demo) for the reference in which yellow highlighted headers are metrics calculated and other headers are copied from input file (as i said 100 + files)

please help me with a macro to automate it