can excel do this?
 

I have 4 worksheets using one as a 'master' sheet. The master sheet includes
one large column of data and several variables that I use for the other two
sheets. What I am wanting to do is to take the data from these two sheets and
insert them within sheet 4.

How can I insert a column from sheet 2 into sheet 4 begining at a
particular row.

How can I insert a series of columns x 5 rows from sheet 3 to sheet 4 under
column that was insertedfrom 2.

Maybe I am making this more difficult than it is. My main objective is to
take all data(single column on sheet 4) output it as txt file. Then take
single column from sheet 2 and output it to same text file (append).Then take
the multiple columns (determined by a variable that I put in master sheet) x
5 rows output it to same txt file.This all needs to be done with macro.
Text file should have data from sheet 4,sheet 2, and sheet 3. My problem is
determining the scope of data in sheets.

Any help would be greatly appreciated.
Thanks,
Jack