Unless you have edited the sheet Code Name that code could not have worked as you have no worksheet with a Code Name of 'Report' - but you do have a worksheet with a Tab Name of 'Report'.
As mentioned by 6StringJazzer change the Code Name for Sheet3 (Tab name: Report) to 'Report'
There are advantages to doing that. The main one being it prevents code errors if the user should change Tab Name...
Also, you may not need to define Worksheet objects as you can refer directly to them using the code name. The declaration for ws (in the quoted line above) could be removed as could that line itself. Then when assigning to the bookmarks you'd simply use