I have:
WorkbookA with Worksheets A, B, C, and D.
WorkbookB with Worksheet Z.

I want:
To replace sheet C with sheet Z (i.e., WorkbookA now contains sheets A, B,
Z, D).

Any suggestions?