Is it possible to have an entire row in one worksheet dynamically change based on the contents of a cell in a separate worksheet? Attached is the workbook.

What I want to do is have the Acute tab pull the entire row from Overall tab IF the Overall C:C cell equals "Acute." If it doesn't equal that, then just be blank.

I don't know how to do anything with VBA, so I would need to do this as a formula/other function. Thanks!Dynamic Rows Help.xlsxDynamic Rows Help.xlsx