Based on what you've described, my initial thoughts were to use bookmarks to put both sheets on the same dashboard. You could then create parameters to filter across both sheets--there are lots of threads and articles out there on how to do this:
If you have trouble setting up a global parameter filter, then I'd suggest posting a new question/thread with your packaged workbook (or a sample mock up using the Super Store dataset). Someone will be happy to help you create a parameter that filters both data sources. If you have LOTS of filters, this could get to be a bit of work.
You can also use action filters to filter across data sources; not sure if that would help in your scenario or not.
You might also consider only displaying one sheet at a time, based on a parameter selection:
Best of luck.
thank you. youve given me hope! i will work on this.