for each sheet with first 3 char matching variable, copy column C to Target sheet unless..

So I've been trying to Copy Column C from Each Sheet that starts with "STU" to Sheet("Target") starting at "A2", there will be other sheets not starting with "STU" but if add additional sheets starting with "STU", I want to enter only the new info to the next blank column stating at row 2.. I'm using the sheet names as the A2 header, then filling in the info under the header, A3.
I've manage to copy the code, use only the sheets i wanted, but it i ran the code a secong time, it just adds all the sheets again, I've tried using application.worksheetfunction.match, tried coping sheet names first, then check cell values against sheets, but am unable to figure it out..

here's the code I've butcher, please don't laugh too hard, I'm trying

Please Login or Register  to view this content.

there's other code, all under workbook, but it doesn't function
and heres the workbook
StuTest V1.xlsm

Give this a try. Put into a Standard Module not the worksheets module.

Please Login or Register  to view this content.

..................

Originally Posted by mike7952

Give this a try. Put into a Standard Module not the worksheets module.

Thanks Mike, that worked great, I did added a quick sub to delete blank rows then called the one you posted only because it was static here

Please Login or Register  to view this content.

but again thanks for the assistance, I've never used "Like", i think that could solve a great deal of problems i've had in the past.
thanks again,
-Daniel

Marked Post as Solved and added to Rep, Thanks

@Jindon,

Why would you post Password Protected Workbooks? Makes no sense!