Shift Rows Obstructing Spill

I'm getting a "spill error" when I try to reference a table from another worksheet because there's text in a cell that is in the way. I understand that. My question is whether there's a way to have t...