Extract Items From List

Hi, Folks. I'm a newbie to the forum and don't hold myself out as an expert on Excel. However, I have been using it to run my businesses since Excel was 400k on a floppy disk in the 80's, and I'm comfortable with macros and functions. I've been searching the net but haven't found an answer to this problem that will work for me.

I'm developing a maintenance tracking system for a towboat company. There are separate workbooks for each boat with links to a management workbook. The Maintenance Log in an individual boat's workbook is a simple growing list that will be cleared, (except for the outstanding items), at the end of each year to keep it from becoming too cumbersome over the years. Following are the column headings in the maintenance log:

Date Requested

Category (Engines, Pumps, Electrical, Safety, etc.)

Maintenance Requested (a wrapped text cell filled in by the maintenance department showing what needs to be done)

Days Outstanding

Date Cleared

What I need to do is extract only the uncleared items from a boat's Maintenance Log and list them in a spreadsheet in the management workbook. (At any given time there shouldn't be more than 10-15 items outstanding on a given boat.) So, I want to look at only the rows that contain data, check to see if the item is cleared and, if not, pull the information from the first four columns of the maintenance log into the management workbook in list form. Can this be done?

Thanks in advance for your help.

Mike