Excel problem

I have an excel spreadsheet, with about 50 colums of user data. On a second workbook, I made a small report form, that will contain the information from one of the 50 colums.

I want to know how to automate having the form filled, with data from one of the fifty colums.

For example, if I need to print the data in colum 23, how do I tell the form to get the data from that colum?

I need to do this exactly this way, as the form also contains other data. Therefore I can not simply print the colum itself. Also I am only taking certain cells from the colum, into the report form.

Hope I made this clear!!
Thanks