Populate Column With Unique Values From Another Sheet

Hi all!

I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this sheet we'll call "Hours by Company". The reason I say another sheet and not a report, is because I will have to do some custom formulas for data manipulation (to monitor hours spent of each company). As we have it setup, the company name is manually entered on every row for the "Requests" sheet, what I would like is to make a cross sheet reference to "Requests" and populate a column with all unique names found throughout the "Requests" in "Hours By Company". I'll Link below mockups of each sheet, as with just words this can be confusing:

Here is a mockup of the "Requests" sheet:

And here is a mockup of the "Hours by Company Sheet" I am trying to build:

The goal here is to grab all unique values from the "Company Name" Column in "Requests", and populate the "Company" Column in "Hours by Company". Is there a way to do this in Smartsheet? Thank you for any and all help!