Compile a list from 1 worksheet and copy or populate a new worksheet within the workbook

[cblgod1]

I am attaching the file in its current state........ All of the info needed is on the comments page or 2 page in the workbook.
Any help will be greatly appreciated.

The request, for others that may search for the same answer is.......

Need a list to populate on another worksheet using data (conditions) from another.

Example.
Need all Locations, that need repair/replacing or need to be watched, to populate a list on another worksheet. Which will allow
the technician to type in comments on the repair needed. Then print it and add to the service contract.

I also need it to adjust the list to fit as many locations as necessary.


Thanks a mil!