Here are two methods to filter data by the value of a linked cell in another sheet:

Method 1: Using Indirect Reference with Filter

1. Go to the sheet you want to filter.
2. Select the data you want to filter. This could be your entire table or a specific range.
3. Go to the "Data" tab.
4. Click "Advanced" in the "Sort & Filter" group.
5. In the "Criteria range" box:
- Enter the cell address containing the value you want to filter by, prefixed with an equal sign (=).
- Since this value is in another sheet, use indirect referencing: `=Sheet1!A1` (replace "Sheet1!A1" with the actual sheet name and cell address).
6. Set up your filter criteria in the following rows:
- In the first row below the cell address you entered, copy the header of the column you want to filter by (assuming it's in the same row as your data headers).
- In the second row below the cell address, enter the comparison operator (e.g., "=", ">", "<") followed by a wildcard (*) if needed.
7. Click "OK".

Excel will filter your data based on the value in the linked cell from another sheet.

Method 2: Using Data Validation and Advanced Filter

1. On the sheet containing the data you want to filter, create a dropdown list.
- In a separate area, list the values you might want to filter by.
- Select the cell where you want the dropdown list to appear.
- Go to the "Data" tab and click "Data Validation" in the "Data Tools" group.
- Set "Allow" to "List" and define the "Source" as your list of values.
2. Apply a filter to your data. Select your data table and go to "Data" > "Sort & Filter" > "Filter". Filter arrows will appear on your header row.
3. Use the Advanced Filter option. Go to the "Data" tab and click "Advanced" in the "Sort & Filter" group.
4. Set up the criteria range:
- In the "Copy to" box, enter the cell where your dropdown list is located.
- Click the checkbox next to "List criteria range".
5. Define the range to filter: Select your data table.
6. Click "OK".

Now, when you choose a value from the dropdown list, Excel will filter your data based on the selected criteria, which is linked to the value in the dropdown list cell.