Right click on the tab at the bottom of the worksheet and select Move or Copy
you then get the option of where you want to move it to - do this for each
sheet and copy to the same location.

"Frank" wrote:

I have 3 different workbooks each with one sheet. I want to combine them
with to become one sheet/book to be used by three different groups of people.