|Drop the quotes and the ampersands.|
When a value is assigned to a variable, you just use the variable:
You rarely have to Select an object in VBA to perform an operation on it. You can refer to the object and perform the operation in one step:
can be reduced to:
Heck, if you wanted to, the whole thing could be reduced to one line:
Sheets(InputBox("Enter the Report Name.")).Copy
Ain't VBA fun?
Posting Tip: Before posting Data or VBA Code, read this How-To.