Collect data from multiple sheets

Hi,

I've some problem trying to collect data form multiple sheets after rows (with additional information) are added.
Excel does not seem to want to bring the newly added rows with information with it to my "summary sheet" (see attachment).

Not really interested in using Pivot table.

Any suggestions?

Much appreciated.

Hi xe-dingo

I have a solution that works.

Currently it is set up so that any row marked with an "s" will get posted to the summary by clicking on the blue button. It can easily be changed so that all unposted items (from all sheets) could be posted to the summary.

Let me know what you think.

Regards
Alastair

Hi,
I think ,that Microsotf Query may be proper solution of Your problem.
Define two ranges (one in sheet Group 1, second in Group 2) and refers to them in SQL Query. if You write new records either in Group 1 or 2 then you will have to refresh report. New records appear in report.
Regards