I need to combine contents of about 30 sheets into a single new worksheet. I need to do this on a daily basis. I was wondering if there is programmatic way to solve this, instead of "Cut&Paste".

On the flip-side could you break a single huge worksheet into multiple sheets for easier user navigation.