Selecting specific info from a table

DarylinJ 

There are multiple ways to achieve that and it depends on you that which method you are comfortable with.

1) You can have a dropdown list of all the Contractors in a Cell on another worksheet, place the header of all the columns of your data in an empty row and then use an Array Formula Index/Small to pull all the related data for the contractor you selected in the dropdown.

2) You can use Advanced Filter to either copy the data related to a specific contractor to another location or filter the data in place.

3) If your data is formatted as an Excel Table, you can insert a Slicer based on the Contractor field and if you select a contractor from the Slicer, the table will display the data related to the selected contractor in the Slicer.