Is there a way I can automatically create a new formatted sheet based on a
template when a user enters data in a master sheet.

for example, the user enters data into sheet A, if data is entered into a
particular column sheet B should be automatically created based on some
standard formatting in hidden sheet X. It is likely that there will be more
than 1 sheet B.

Any help in providing a solution would be appreciated.

--
neil