I'm doing a pivot table with multiple ranges, as suggested here in the group.
Works well for 4 sheets, but I'll probably have 40.

Would it be possible to do a 3d formula to catch every sheet in the workbook,
instead of listing each sheet in the pivot wizard ?

Thanks much

Mike