Hi. Got a client who wants to add features to his excel file. Hoping someone here could help.

Got a xls file with 400 sheets, one sheet for each widget. On each widget sheet is an area for people to enter maintenance logs.
Log entries (rows) include a column for the date, description, price, status, an whether it's preventative maintenance Y/N. Need a
couple of things: One, I need to create a summary sheet (400 rows) showing the most recent log entry of each widget. Two, I need
another summary sheet but only showing those widgets those most recent log entry is flagged preventative maintenance.

I asked last week, but didn't get a response. Probably the holiday. Any advice would be greatly appreciated...Dennis