Different Range Lookups
 

Hi,

Please Help....

I have 3 sheets with a varying range of data on. These are all indivdually
named. I would want to produce a main sheet that combines the 3 into 1.

I have a job number column in all 3 ranges that is unique to that range. How
can I write some code to copy the job number from range 1 and paste in new
sheet and then copy range2 and paste at bottom of range1 in new sheet and
copy range 3 and paste at the bottome of range2 in the new sheet? the problem
is that each of the 3 ranges have a varying amount of data.

My next problem is how could I have a lookup to pull back data against the
job number column looking at either of the ranges?

How is the best way to do this??

Thanks,
Jez