@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.