Hi Everyone,

First ever post from myself so here its goes......

Very basic skills at using VBA to do things such as rotate a 3D graph at the click of a button etc....... complete Amatuer

The Problem :

I have a sheet which has multiple tabs which are identical in everyway other than the individual who inputs the data (each tab represents a different programme/project in a portfolio of work).

Currently i have a totals sheet at the end which i have set up to equal a cell in another tab. This works to an extent but it means im constantly having to add extra rows and drag formulas down to remove blank cells or add more rows.

Is there anyone out there who would be able to produce a code which would pool all of the data from each of the tabs and then place it in the master tab? also would it be able to not 'pool' any rows which dont contain any data along with not including the headings row (row 2 currently).

Hopefully i have articulated the problem reasonably well.......if not heckle away and i will have another go.

Cheers