Hi,

When you do a "Range( ).Select" it works on the active sheet (the one you are viewing). You will either need to Select your different sheets in the code or do a With Worksheets( ) type of statement in your code to get data from different sheets.

Look at http://www.ozgrid.com/VBA/sheet-index.htm for the example.

Note - when using the WITH Worksheets type of code ".Range" is dealing on the WITH sheet and "Range" is dealing with the current/viewed sheet.
This period in front of Range or Cell is such a small dot but it has such GREAT meaning.