Extract cells
 

I have about ten worksheet with difference names in one workbook, I
will like to have a vba /formula extract parts of each row of every
time I enter information in that worksheet after I press enter eg if
row 3 have information's from a1 : h5 I will like to extract c1,d3,f5
and g4 cells these cells information's must be send to my summary
worksheet automatically in the same workbook in order of date / number
Can you help

Extract cells
 

Why not just use formulas on your Summary Sheet?

= Sheet1!C3
= Sheet2!F4


" wrote:

I have about ten worksheet with difference names in one workbook, I
will like to have a vba /formula extract parts of each row of every
time I enter information in that worksheet after I press enter eg if
row 3 have information's from a1 : h5 I will like to extract c1,d3,f5
and g4 cells these cells information's must be send to my summary
worksheet automatically in the same workbook in order of date / number
Can you help