vba - output Selections from worksheets
 

I need to output several "sections" into one tx file and am confused how to
do it.

Here is what I am needing:
Sheet4: a1-a166
Sheet2: Entire A column - this could vary. I dont know how to determine last
row
Sheet3: Column count varys - I have a variable in sheet1(Sheet1!E2) x 5 rows
Sheet 4 a:626-a656

Can I use a varible to save as Sheet1!D2.txt

Any help would be greatly appreciated.