I just finished a multisheet idw. Assembly was on sheet 1 and parts and sub-assemblies where detailed on subsequent sheets. I added a custom column to the parts list with the heading of SHEET. If part xyz was detailed on sheet 4 it was indicated with a SHEET 4 in the parts list. If xyz was detailed on sheet 4 and appeared in a sub-assembly on sheet 3 it was indicated with a SHEET 3, 4 in the parts list.
It would be nice if this could be done by software instead of searching for locations and typing in edits.