I really hope to have some help with this as i am very basic at VBA i can run them but not create :P!

Hi Excelers:).

Maybe I will not be the best to explain but please let me know if you need further explanation.

I have different workbooks (around 20) and they give the information about different products for the branches, so in all those workbooks the code and the name of the branch and the info starts at B8:B52 and goes on on F8:F52 so for each branch the starting cell number is 8..now I want to do a summary for each branch with those information on the 20 workbooks. I do the first branch that starts at 8 so i go =workbookx, d8 and so on and then copy this one to the other sheet, and as there the common value is 8, i go CTRL F, find 8 and replace with 9 but at the same time keep the 20 workbooks open and it does replace all the values so make the changes for the righ branch that starts at 9...and i go on with the same paste the first one so with value 8, and i go replce with 10 and so on....this is an easy way that I did found but i would like to do it with a macro as it will not be a boring job and will same me a lot of time and to be honest i love what macro do .

but what i would like is that if i do the first sheet ready with the info, i want the macro do save the next sheet with the code of the branch, where it will copy it let's say B8 and the name at the top of it the branch name.

Please, if you need a sample i can attach it.

P.S I did search in the internet about it and i looked at around 20 links but still, but i can't find what i look for.

Thank you a lot.