Finding and copying worksheets to active workbook

[Still learning VBA]

Hello MrExcel,

I am fairly new to VBA and its all functionalities, so I wonder if you guys can help me out a little.

Every month I receive an Excelsheet containing raw data which is divided over several worksheets. To be precise it contains exactly one worksheet per item and the data within each worksheet is identically organized.

I created a masterfile to which part of the raw data should be copied (I'll come to this in a minute). I have put together some code which opens the raw data file and there it stops for now I have been looking around for code to do the job, but couldn't find the right thing so far. So that's why I am turning to you.

There are three things I would like the script to perform:

1. I have a list with the precise names of the worksheets, so I would like the script to use these names to go to each worksheet and
2. copy three columns (A, C and E) to the masterfile and
3. Furthermore (to complicate things a little more) I would like the script to copy only those lines for which column C contains a value.

I hope this gives a clear enough idea of what i am trying to do.

Any help would be much appreciated, thank you

 

[texasalynn]

1. I have a list with the precise names of the worksheets, so I would like the script to use these names to go to each worksheet and

what is the name of this sheet?