With the help of Excel BI toolkit, you could always create highly interactive reports by multiple range of sources and model data based on requirements.