Create worksheets from data in sheet1 (VBA script?)

[ShadowRider]

I asked this a few weeks back and did not get any hints. Trying again

I have a worksheet with header block currently sized a1:eJ and rows with data (Header is likely to widen over time). I have two separate types of worksheets I'd like to create with this:

First, individual sheets for each row of data so that the new sheet contains links back to the row of data in sheet 1. For example. Sheet1-row5 contains
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Jon[/TD]
[TD]Doe[/TD]
[TD]Engineering[/TD]
[TD]foo[/TD]
[TD]bar[/TD]
[/TR]
</tbody>[/TABLE]


I'd like a sheet named "Jon Doe". it would contain links to sheet1's header (a1:eJ) and also links to the row that contains Jon Doe's data. I'd like links instead of just copying data so that if the header or data in sheet1 changes, the data on Jon Doe sheet also changes.

My second set of sheets is similar to the above except I'd like sheets named "Engineering" or whatever is in column C on sheet1's rows. The data on that sheet would have the same header links as before but would contain rows of data links for all rows on sheet1 with members in that department.

I'm using Excel 2016 for the MAC but am sharing the spreadsheet with windows users so I'd like something that is compatible for both if possible.

Thanks in advance.

hints are welcome!