lookup particular value in different worksheets and take range to one sheet

[privba]

hi,
I have 8 to 15 sheets in a workbook .I want to check the first column(A) of each sheet and check if it is july2006.
from whatever cell the value is true I have to copy the range from column B to a new sheet.It should be repeated for number of sheets in the workbook.
so suppose I have the data like this
may 2006 .25
june 2006 .24
july 2006 .26
aug 2006 .27
sept 2006 .27
oct 2006 .28

so I will have to copy the data .26,.27,.27,.28 to a new worksheet.I am attaching the sheet too.
Thankyou for your help in advance

[arlu1201]

Do you mean entries > july 2006 as you have stated in the example Or is it entries = july 2006?

[privba]

yeah it is entries > july2006

[arlu1201]

Should the sheet name be mentioned in the output, from where the data has been copied?

[privba]

I am new to vba so
I tried working the code like this
columnscopy

Please Login or Register  to view this content.

Its working fine except in the end it is giving me one extra column (i.e. copying 1st column from sheet1 again instead of exiting out of loop)
It should come like this
column1 column2 col3 col4 col5 col6 col7 col8
Fixed Income Core TIPS equity International Equity Large cap Small Cap Absolute Returns REIT
instead it is coming like this (where col 9 and col 1 are same)
column1 column2 col3 col4 col5 col6 col7 col8 col9
Fixed Income Core TIPS equity International Equity Large cap Small Cap Absolute Returns REIT Fixed Income Core

I am not able to find what is the problem .I added watch also but not able to figure out what problem is

[arlu1201]

You should put all code within code tags. I will review your code, what about my questions in post 4?

[privba]

Hey Arlette

Thank you for your reply .
For post 4 I replied before but doesn't seem to see the answer here .I am new to this forum so don't know where did I replied it .
Anyways I do need the name of the sheets at top of columns .
For post 5 I figured it out that I was using consolidate as sheet name instead of Consolidate(Uppercase C).So it works fine now .
However I am not able to find how to copy from a particular column .