Break down the task into as many smaller components as you can manage.
Ex:
- Retrieve a list of all sheets.
- Collect all of the views for each sheet.
- Collect all of the scales for each view (@simon_murphy1 has shown you up to this step)
- Simplify each sublist down to Unique Items.
- Replace the scale numbers with standardized scale notation (for instance [1/8" = 1’-0"] in Imperial)
- Sort the sublists so the scales are organized consistently.
- Convert the sublists to single multiline stringtext
- Have an instance parameter in the sheets established to report multiline text.
- Plug the multiline stringtext into the sheets.
Here’s some reference material for step 7.
Everything else should be manageable with standard Dynamo nodes, post updates if you’re stuck (or even if you get it to work, it’s useful for the next person to reference finished graphs).