Numbers: Line graphs for cell values across multiple worksheets
Hopefully someone knows how to source data from multiple table inputs, but I just use brute force and make one table that contains all data I need to chart. Tables can refer to data from multiple other tables, so now with your charting data in one table, charting becomes a snap.