I added a column next to a Pivot Table ("Comments"). When I refresh the
Pivot Table and it imports new data, the format of the Comments column
becomes out-of-sync with that of the refreshed Pivot Table. No problem: I
copy column D of the Pivot Table and Paste-Special/Formats to the Comments
column (column E) to update that column's format to match the Pivot Table.

How can I automate this, so when the Pivot Table changes the format of
column D is automatically copied and pasted to column E?

Thanks.