The standard KPI object will allow you to link to a sheet but there is no option to use this to pass through a value.
Could you try adding logic to your table that filters the records based on their status e.g. using set analysis only display open tickets? This would then give you the consistency across sheets that I think you are looking for.
Perhaps you could consider using an extension such as the Variable Button (Variable Button) to allow you to show the KPI value and then, when it is clicked, it sets a variable read in by the expression in your table?