I have the following formula:

=VLookup(A2,Schedule!B:H,7,False)

In my workbook I have 60 worksheets and I need this formula to be entered
into every single worksheet in cell A1. Is there a macro to do this?

This would save me lots of time. Any help would be great. Thanks,

Mike