Ok, this is my final plea for help. In my workbook, all worksheets are
formatted the same. What I seek is a macro which copies a range, say B2:B8,
in each worksheet, and places the values for each worksheet in the last
worksheet of that workbook. However, the values should be HORIZONtALLY
pasted next to each other.

Thanks Tremendously

(PS: All the more fantastic if the values could be pasted to a new workbook)