With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.