You cannot create a new worksheet by use of a worksheet function alone;
for that you need to get into VBA. If you're willing to tackle writing a
program
in VBA/Excel, try re-asking the question in the Excel Programming forum.

--- "chewy70" wrote:
I have a large database in a spreadsheet. There is a list of financial
professionals and thier firms. For every change in the firm I want to create
a separate worksheet. Which function allows me to do so, rather than copy
paste?