generation of a summary sheet from multiple sheets with filter criteria for data lines.

Guru's all.

I hope you can help, I am stuck and in need of some advice and guidance from the Watu....appreciate your time and effort in supporting a luddite...

Aim:

To create a summary sheet of filtered results based on text criteria (open/Closed) from multiple sheets within a workbook.

Example.

Daily sheet is generated containing safety observations (30-40 per day) each carries a status - open or closed.
a workbook is generated for the month (28 days)
Multiple workbooks for the year


I have attached an example with two sheets of raw data, a worked up summary for example results - hope this helps.

ideally I am attempting to summarise all the 'open' items from each daily sheet into a summary sheet for control - an open issues list/task list if you like, expandable as each day is populated within the workbook ( a P2 would be then to do the same for each month) and updating to show 'open' items.

I have tied this with HLOOKUP and VLOOKUP but my skillsets are just too thin at present (I'm still persevering !!) and I think I am on the wrong track, and think this is a macro/VBA task which is way beyond my Ken...

This may be better suited to a database, but excel is the current format for data entry and analysis.

Ideally, the summary has write back functionality - to the original data - not sure if this is possible ??

All suggestions gratefully received - every day is a school day !!

Many Thanks for the help

A.