Automatic Filtering Option

I am trying to make the table lookup the value in the different cell (diffrent worksheet) and filter the table (it doesn't have to be a table) by this value. Please the attached file. I would like to enter company id into cell J2, so column C (company ID) could be automaticly filtered by by this value. Is this possible?

You can make it automatic on a different sheet, leaving the original table untouched - would that be suitable?

Pete

Pete, it may be suitalbe. I am not sure how it suppose to work. The actual table is huge 90k rows. I don't want to pull all this data with formulas. It will be too slow.