You can hi-light then "right click" and "Cut" the selection out.

Then move to the new combined sheet and "paste."

This will leave all formulas in the sheet the same, the only problem you may
face is if you have list boxes that are referenced somewhere you will have to
do those again.

I have done this a few times myself, and it works well for me just needs
some tweaking to get all correct.

"Lesa" wrote:

I have many worksheets within one workbook and I want to make a new worksheet
that contains ALL of the data from all of the worksheets into one worksheet
so that I can sort that one huge worksheet. How can I accomplish this?