Import multiple text files into 1 workbook

I am a novice and needed to know how do i import multipule txt files into 1 workbook

Date Time Well_1_8ft Well_1_6ft Well_1_4ft Well_1_2ft Well_1_0ft
11-19-2012 00:02:53 25.480 25.310 25.780 26.300 25.810
11-19-2012 00:07:53 25.510 25.250 25.750 26.280 25.780
11-19-2012 00:12:54 25.480 25.280 25.750 26.280 25.750
11-19-2012 00:17:54 25.510 25.280 25.750 26.280 25.720
11-19-2012 00:22:55 25.480 25.280 25.720 26.300 25.750
11-19-2012 00:27:55 25.510 25.280 25.750 26.300 25.720
11-19-2012 00:32:56 25.540 25.310 25.780 26.300 25.690
11-19-2012 00:37:56 25.510 25.340 25.780 26.300 25.720
11-19-2012 00:42:56 25.540 25.310 25.780 26.300 25.690
11-19-2012 00:47:57 25.540 25.340 25.780 26.300 25.690
11-19-2012 00:52:57 25.510 25.280 25.750 26.280 25.660
11-19-2012 00:57:58 25.510 25.280 25.750 26.280 25.630
11-19-2012 01:02:58 25.400 25.160 25.630 26.160 25.510
11-19-2012 01:07:59 25.480 25.280 25.750 26.280 25.600
11-19-2012 01:12:59 25.540 25.340 25.780 26.330 25.630
11-19-2012 01:17:59 25.540 25.340 25.780 26.300 25.570
11-19-2012 01:23:00 25.570 25.340 25.810 26.360 25.600
11-19-2012 01:28:00 25.540 25.340 25.780 26.300 25.570
11-19-2012 01:33:01 25.510 25.310 25.720 26.250 25.540
11-19-2012 01:38:01 25.540 25.310 25.780 26.300 25.570

Paste the following code into a Spreadsheet named : "Summary Sheet.xlsm"

When it is run it will open every text file in its host folder and paste them one after another onto the summary Sheet.

Enjoy.

Please Login or Register  to view this content.

any ideas on how this is acomplised

thank you i am getting an error message "block if without end if"

thank you however i have over 500 files of this type that i need to input into one worksheet

My apologies

I simplified it for you and messed it up.

It works now.

thank you now i really feel dumb how do i get this to run?

I have added a button on this for you

Thank you so much for all your help ! one question... i get an error message that says the macro may not be available in this workbook or all macros may be disabled so i went to the developer and set the security to enable all macros however it still give the same message

My apologies

If you had right clicked on the button and selected edit you would have found that the button was linked to a macro called Summarise_Sheet.

However I had renamed the macro Summarise, hence the error. The macro it was looking for didn't exist.

I have checked the attached version and improved on it for you.

My apologies.

Thanks alot!! live saver....