I suggest that you post a document that contains representative date and the relevant sheet objects. Be specific about what you want to see when a date range is selected. More information will mean less guesswork and more accurate advice.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein