The spreadsheet I'm working with has multiple tabs for data, and each tab/sheet has a graph on it.

I want to combine all of the multiple graphs into a single graph on a separate sheet, is there anyway to just copy the data and formatting from the multiple other graphs into a single one, without having to go through "select data > add " and selecting everything on each individual sheet?

Like can I somehow just tell the master graph to get its data from the other graphs without doing it manually?