I am trying to create a macro so that when a selection is made on the drop
down menu, it would apply for all the other pivot tables.

While I found great examples in http://www.contextures.com (great site by
the way) I have no idea how to create the macro or modify it to meet the my
needs.
Is there a good book or reference to start learning Excel macros?

Thanks,

PJS