Is there a way I can use AutoFilter or an Advanced Filter to return values
that are Less Than or Equal To a value that is the result of a formula?

Example: I have certain values typed into Sheet 1. On Sheet 2, I pull these
values into the row above my column headers. I'd like to filter these columns
to show values that are Less Than or Equal To the values from Sheet 1.
Currently, I have to manually enter these values into a Custom Filter for
each column to display the values and there are about 20-25 columns to
filter. I'd like to find an easier way to do this, possibly by creating a
macro that can filter based on a cell value, rather than having to manually
filter each column for values that are constantly changing.

Is it possible? Or do I need to continue doing it manually?

Thanks!!!