Copy rows from multiple sheets to new workbook based on today's date

[pisanoal]

Hello folks,

I have a workbook with multiple worksheets that is an operator log. The operators will make entries on the worksheet several times throughout the day. I'd like to utilize a macro that they can run every time they add data that will copy the data into an identical workbook. The original workbook is password protected to prevent other people from making changes, but I need a workbook that I can automatically update from in Power BI. Protected workbooks do not allow this as of yet.

The macro needs to check today's date and either copy any new data from all sheets into the correct spot in the other workbook, or copy the entire row from each workbook that corresponds to todays date, and copy it into the new workbook for the same date record. From the second run of the day to the end, it would be overwriting the existing row with the second option.

I'd love to learn enough VBA to do this myself, but i'm already working on learning Power M and DAX, and i could use a solution faster than i could learn to create it.

Thanks in advance!