Copying Rows from Multiple Tables into One

Good morning!

I am new to this forum. I have been searching all morning for a solution to my problem, but have been unsuccessful. It may just be because I am not very familiar with VBA and Macros and I am not sure how to even begin.

I have an Excel File that is used to capture all of the maintenance issues that occur on our boats. I have a separate sheet for each boat. Column A in the sheets will state whether the issue is still "Open" or if it has been "Closed". Different people work on these different boats so I need the information separated by boat for the Engineers to keep track of their boats. (They are NOT computer savvy at all so I am trying to make this as user friendly as possible.) Every Monday, the department needs to go over these issues, so it would not be efficient to click through every tab. I would like to have two other sheets, one for "Open Issues" and one for "Closed Issues" that will automatically populate based on the information typed into the Boat tabs. Can anyone help me with this? I would greatly appreciate it. Thanks so much!

Have a great day!
Veronica