Intuitive Excel Worksheet to Generate Page Layout

[smh1]

I am a programming newbie and am working on creating an Excel worksheet that would make page layout for ad space in a magazine much easier. I've attached the worksheet I have at this point.

Here is what I know how to do already and intend to do:
1. Create drop down menus for columns B/C, E/F, etc. These columns are going to display the ad size and placement on the page. Each page is represented by the rows (page 1=row1, page2=row2, etc)

This is what I need help with:
1. I want the Client names (Joey's Diner, Bob's Glasses, etc) to be in a separate worksheet so that I can set up AutoComplete. When someone starts typing the name of the client, they can just hit enter when said clients' name pops up. I've followed this tutorial but I can't get it to work and keep getting an error http://www.vbaexpress.com/kb/getarti...b_id=244#instr. I kept getting the error on the "Set rg=Worksheets" line

Code/
2. Is there any way to code this so that when I save it as a CSV, it will automatically generate the page layout? I don't feel like this is even possible but it is what someone is requesting and I know very little about it so I figured I would ask!

Any help would be so appreciated! Thanks in advance!