VBA Grid x Grid SUM problems

Relatively new to VBA but need some help with some work i have on.

I have Grid 1 53x53 and grid 2 53x53 in different files and need a 3rd sheet to activate the Macro.

the grids need to calc a1xa1 + b1xb1 etc for all the grid and then SUM the answer on the third sheet.

Whilst not sounding so hard to complete, i have a folder of Files which contain different grid 1 and need the macro to run through the entire folder, doing the same calculation and providing me with the SUM of all cells on Sheet three.

I also need it to provide the Name of the file next to the answer it gives me for each SUM so i know which is which.

Is it even possible? and is it possible to specify different grid 2 if i need to in the future?

Ste

everything works up until i need to copy the Sheet 1 from the targetfile and paste it to the mypath file.

plus this needs to be looped and work its way through the folder, and paste the results on a 3rd excel file

Its all secure data, so the actual work books i cant send.

File 1
Where macro will be run from and will store data

file 2
53 x 53 grid of random numbers

File 3
53 x 53 grid of random number

Run process.
File 1 contain a button which when pressed allow the user to specify which version of file 2 they require to use to run against all version of file 3 which are contained in folder.

once chosen, the folder is then specified where the files that want to be run against file 2 is selected. this contains many file 3's

What i need to happen is that file 2 sheet 1 be copied and placed into each of the file 3s in turn as sheet 2. (I have the code to run what i need in the same sheet)

once it is pasted as sheet 2 in file 3 the code will then a1*a1 + b1*b1 etc throughout the entire sheet and give a value along with the file name.

this value is needed to be copied and pasted into file 1 and then the whole thing needs to continue throughout the entire folder specified for file 3's

i shall make a mock up this evening.