What do I subsitute or use in a macro to change a sheet reference I selected manually, i.e. Sheets("Sheet1").Select to take the reference in a cell for the sheet name?

Thanks