Pulling the last records across open sheets

[WazMacNab]

Hi folks, first question and it's a doozy for me...

I have a workbook with multiple sheets some hidden and most are at the moment active. Basically I run a meeting and each sheet is a project with feedback, that starts in column V (Date) and spans another 2 columns, w=Milestones/Comments and X=Status.

I have a dashboard, that I want to populate the last set of comments with tthe latest date (My anot be current day Just last date in list), so I can send out the latest comments to the meeting attendees


Active Sheet with Comments

Dashboard I want to overwite with Sheet name (Initative Number) latest Date and Associated comments

anyone out there that can assist..?

much appreciated.

 

[WazMacNab]

Forgot to mention the open sheets are all numerically named, and as in the first image, all the data starts in V1. Date, Notes and Status.
On the dashboard sheet, I'd like VBA to run across the active sheets and copy the last row/s data (V#, W#, X#). Depending if the last date is a single row or multiple rows of the same date as long as it's the latest date in the range.

tnx
Waz