Table function question
 

Hello,

Is it possible to reference cells on a different worksheet then where
you run Table? For example, I am creating the table on sheet 1.
However the row and column references I want to use are on sheet 3. I
am getting an error saying "input cell reference invalid." Is there
any way for me to accomplish this without having to create the table
on sheet 3 - which does work?

Thanks,
Scott