Generate register of information created using macro

[Nicky1226]

I have developed an information request register that populates a new tab using macros. I want the Register to automatically generate the list when a new tab is generated. I can't find the info on how i can do this however. Can someone please assist with the details? Workbook attached.