Creating multiple sheets based on one sheet

Hi All -

I'd like to use the information in one main spreadsheet to created multiple sheets automatically.

For instance, on sheet 1 there are several rows containing information individual employees. Based on this, I'd like to automatically create individual sheets for each employee on the following pages.

I can link the information on say sheet 2 to sheet 1 but is there a way to do it without manually creating new sheets and entering the formulas for each section.

See the attached excel as an example. On sheet 1 (or overall staff summary), there is information for various employees. On sheet 2 there is an individual staff file - i've linked the information from sheet 1 to automatically appear. But how can I make this happen for every single employee on sheet 1 (theres over 100) without manually creating each page?

I have the feeling that this is possible but I have no idea how, would greatly appreciate any help!!