Filtering based on cell

[megangrace123]

Hi! I'm new to VBA and need help. I have a column on one worksheet titled "Profit" that has various numbers listed in column C that correspond with the accounts in column A. On another worksheet titled "Total" I have a cell that I need to filter by. I'm trying to come up with an "If" statement that allows me to sort the numbers in column C on worksheet "Profit" by a cell (A6) that is constantly changing on worksheet "Total". I want only the Accounts with numbers greater than 100 to paste onto worksheet "total". Any help would be much appreciated