Hi Jim,
I have not done this via this method, but have done embedded dashboards for the same type situation. Maybe this would be helpful in case you want to consider this direction too.
There are screenshots exactly how to go about it. Dashboard within a new sheet
Nancy