Copying data from other workbooks and pasting into master workbook

OK so I have tried everything I can think of to modify this macro I pulled from the net but I keep getting errors. I don’t know where I am going wrong in addition to my limited knowledge of coding macros has really put me in a bind. I need this macro to prompt me to select a workbook(s) then copy everything on Sheet2 to my master workbook until all of the source workbooks have been processed into the master.

Here is my code. I have reverted it back to the original I copied from the net because I butchered the original too much.
I have also included my sample data.

Please Login or Register  to view this content.

UNSPSC_v14_0801.xlsUNSPSC_v15_1101.xlsMaster.xlsx

First correction

Please Login or Register  to view this content.

Nope not error, The macro sems to let me select the file, then the screen flashes, and the macro ends. It never goes past this line:
I got it past this line once but it thew an out of range error. Sorry I didnt make note of the actual error code.

Please Login or Register  to view this content.

@ AB33 - Both my original line and yours seemed function properly but nothing actual goes anywhere after that. Just terminates the macro.

I meant A through D. Dang it. ok so I placed a : between all the ranges and I now get a Run-Time Error 1004 at this line:
LastRow = SrcWkb.Worksheets(2).Cells(Rows.Count, "A:D").End(xlUp).Row

The sheet names in the master file are Sheet1, Sheet2, Sheet3 but the source file names are custom per tab. I want everything off of tab two Columns A:D. Which parts of the code do you feel is unnecessary? My coding experience is REALLY rusty.

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

I will be off site until tomorrow.

Lastrow Should be "D". Here is what I have now and it does run through the sheets but it doesnot paste the values in the master fille.

Please Login or Register  to view this content.

This is my guess work on what you are trying to do.
You should have master book with sheet1 as a destination sheet. Sheet1 has also a header.

Please Login or Register  to view this content.

AB33 - Thats exactly what i am looking for. Thank your for your help. You are a life saver!