I use the following formulas to automatically populating cells for a single record in my sheets:



A='sheet1'!BG6

B='sheet1'!FW6

C='sheet1'!BA6

D='sheet1'!BP6

E='sheet1'!Q6

F='sheet1'!O6

G='sheet1'!L6

H='sheet1'!E6

I='sheet1'!D6

J='sheet1'!A6

K='sheet1'!CI6



Now my problem is that I have got over 200 records.Please help so that this formula is working for all records when selected randomly.



For example if i want a record on number 5 i should not enter its on formula.the above formulas is for a record on number 6.



Please help.