在多个工作表中替换跨非连续单元的内容——错误1004。

I am an Excel VBA novice and am hoping for help on a bit of code. We have a workbook with four identical worksheets, one for each quarter of the year. What I would like to do is run code on a command button click that replaces identifying name information with generic, sequentially numbered information (I am an Excel VBA novice and am hoping for help