I am trying to write a macro to copy cells in the following pattern:
B1 from Sheet 1 (Actually called Names) into cell AC2 in Sheet 2 followed by;
B2 from Sheet 1 into cell AC2 in Sheet 3 followed by;
B3 from Sheet 1 into cell AC2 in Sheet 3 followed by etc until the end of values in Column B

For the record all sheets contain unique names and do not follow the pattern of Sheet1,Sheet2 etc

Any help would be appreciated.