Proper Syntax for filling out a template on Sheet2 based upon a row number from Sheet1

Thanks. Your suggestion worked fine. This is the first time I've used the Forum and you have made a believer out of me! I probably tried every function but the INDEX. I should have checked here sooner and next time I will.