Autocad can generally do this using good block/family design, and the dataextract command. Dynamo wont make good blocks/families for you, make sure you get that part right first and the rest is just data/list management
Try this sort of approach. It relies on having consistent block origins, names and rotations.
If you are working to a deadline ensure you have time to manually achieve this if you are not familiar with dynamo. Dont try to learn it in a rush as its a hard program to learn that way.