Fill Names in Col A

Hello All,
I have the following problem in Excel 2010. My data shows Name 1 to Name 5 followed by Data in Col B to F as described below:

B5 = Name1 - Data from B6 to F800
B801 = Name2 - Data from B802 to F879
B880 = Name3 - Data from B881 to F895
B896 = Name4 - Data from B897 to F905
B906 = Name5 - Data from B907 - F913

I want a macro to repeat the respective names in Col A viz

Name1 to be filled from A6 to A800
Name2 to be filled from A802 to A879
Name3 to be filled from A881 to A895
Name4 to be filled from A897 to A905
Name5 to be filled from A907 to A913

Any help would be appreciated

TIA

Rashid