How do I create a stacked histogram using data that is on different sheets?

I have 4 sheets all with the same type of data but the figures change slightly on each sheet. I want to bring together all the changes for one item in a stacked histogram but I can't seem to add data from different sheets?

Thanks,
Anna