Hi all,

I have 150 names in Sheet 1 from A1 to A150

also i have 151 sheets in the workbook

I want names to automatically appear in sequence for e.g.
- The name in A1 of Sheet 1 - should appear in A1 of Sheet 2
- The name in A2 of Sheet 1 - should appear in A1 of Sheet 3
- The name in A3 of Sheet 1 - should appear in A1 of Sheet 4
- The name in A4 of Sheet 1 - should appear in A1 of Sheet 5
- The name in A5 of Sheet 1 - should appear in A1 of Sheet 6

and so on

guys all your help is appreciated.

Thank you.
Deepak
maildpak@inbox.com