It can be done. *I've used macros in the past to gather data which is
not sequentially located, then charted the result.

Not sequentially located on *one* sheet, fine. Not sequentially
located on *more than one* sheet is a different matter.