Vba to create a formula to add up figures from multiple cells

[tonywatsonhelp]

Hi Everyone,
I think I might have an Impossible one here
first let's start by explaining my sheet
my sheet has multiple tabs of an unknown number
Sheet "Summary" is where I want to do the calculation
all other sheets are what I want to do the sum on.

Now what I need to do is Get a macro that can create a formula that adds up all the sheets for the figure "Project Management"
the problem is each sheet will have this value in a different Cell.

What I do know is the Name "Project Management" will always be somewhere in column D of each sheet, and the value I want to add up is in E next to it,

Now the BIG Catch is I don't want a macro to sum all these values up, I want a macro that will create a formula to put in a cell that will sum it all up

So Basically if this was in English I'd want something like this,
I run macro,
It goes to each sheet finds the cell that is next to "Project Management"
and creates a formula in "Summary" G24 that adds them all up.
is this even possible?
please help if you have any idea how to do this,
Thanks
Tony

 

[DanteAmor]

You could put 3 sheets: sheet1, sheet2 with examples and the summary sheet with the expected formula.

NOTE XL2BB:
It would help greatly if you could give us the sample data in a form that we can copy to test with.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.