1. Use a do..while loop to cycle through all the sheet names using the
Sheets object.

2. Increment the paste column number by one every loop.
3. Use paste values.

scooper

"al007" wrote in message
oups.com...
How can I copy column B and column E from all sheets to a new sheet
while offsetting the paste ie the 2 column being pasted next to the
other

thxs