yes this can be done... easiest would be to record a macro  of move/copy
worksheet and select new workbook  as destination once you have that code
substitute a variable for the worksheet name and you can just pass the value of
cell a1 to the variable when you rund the macro....