Sure. Do you know how the SaveAs statement works in VBA? You can provide a document name in quotes, but you can also fetch the report title from B2, or wherever, and use that instead.

If you need more explanation then maybe we should back up; I don't know yet how much you know about writing macros...?