How can I copy cell contents from multiple sheets at once?

Question

I would like to select cells in each sheet in my workbook and then copy them all at once, is that possible? Or even better, if I could mark those cells (group perhaps) so that I could get the SUM of them all in a cell directly?

Answer 1

the sum function accepts multiple ranges =sum(sheet1!a1:c3, sheet2!a1:c3)

Its not possible to copy multiple ranges at once for the simple reason that, how could you then paste those ranges, what would it do with the range on the second sheet?