Configure Bar Chart using multiple tables/excel sheets

Hi everyone,   I am trying to configure a bar chart where percentage values and x axis can be configure from multiple sheets.  For example, below is the snapshot of what I would like to acheive whi...