auto copying data from column to another sheet ommitting blanks

[djh100]

Hi

I'm sure this is possible, but compltely failing to make it work. Lots of people seem to be trying similar, but I can't get any of the solutions from the web to work for me. Any help greatly appreaciated.

I have a set of tables that others will fill in (i call these data entry tables). There are up to 30 rows in each table, but usually, only a few will be needed. So each table has maybe 4 lines filled in, followed by 26 blank lines.

I want a summary table to be created automatically, that the users can then cut and paste into a report. This table should contain all the populated rows from the data entry tables.

It would be preferable, but not essential, that the summary table be sub divided into the different catagories - ie a sub heading for each data entry table.

I've tried creating a reference column on the data entry tables that only populates when a row is filled in. This works,but i can't get various formulas I've tried to differentiate between a cell that looks blank because the formula returns "", and a truly blank cell if that makes sense... I would much prefer to avoid macros / VBA if possible, mainly because I don't understand them very well, but have also had problems with them when workbooks are given to other users.

Example spreadsheet attached

EDIT - meant to say, ideally the entry tables would be on seperate work sheets rather than one below the other on 1 sheet as per the attached, but this seemed to add another layer of complexity.

Many thanks in advance

Danny