Function call returns actual code instead of copied range

I am baffled with this. I've never seen vba code pasted in the actual excel spreadsheet before. Here's the code I'm calling:

Please Login or Register  to view this content.

Here's how I'm calling it:

Please Login or Register  to view this content.

Here's what is returned and pasted in the spreadsheet:
Sheets("Analog").Select
ActiveSheet.Paste
Application.CutCopyMode = False

Any suggestions on how to copy and paste the range instead of the actual code would be great.

Is the only thing that you changed was the arguments for GetInputAndCopyData?

OK. I see that now. I ran the code and I'm getting the following error: Paste method of worksheet class failed using the following code to call the above corrected code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I may need to clarify something. What I'm doing is, adding worksheets from another workbook into my workbook, say I import a worksheet named Sheet2. From "Sheet 2", I want to copy all data in column "EMS Composite Name" and paste it in "Analog". If I run the following, again, it pastes the actual code in my worksheet.

Please Login or Register  to view this content.

It is a column header. So I pass the worksheet name and header name, then search for that column and then copy the data under it, return the copied data and paste it into another worksheet.

It might help if I told you that the header is located on row 6 and there are about 15 other names on that row, so I need to select the correct column with "EMS Composite Name" in it.

The jpg attached shows a quick illustration of what I'd like to do. Also, if it's easier to just go ahead and paste the copied data instead of returning it and pasting it, that will be fine too.