Graham,
The OP got me to tinkering this morning
Place both the attached files in the same folder. Open the Word document and click in the various controls and you will see how CCs can be populated from:
1. Named columns
2. Named ranges
3. Named sheets
4. Filtered data.