Update row/columns based on another column's data VBA

Hi All,

I want to transfer all the id numbers from Data Sheet (column B6:B10000) to the Cover Sheet row #5, if the id is not exist in data sheet (row #5), then extend the formulas in C6:C10 until end of the data in row 5
For Example, the id numbers in the Data Sheet is from 1 to 15 so, I want to update my Cover Sheet with another 8 id numbers (8-15), and the expected result would be same like in the ?Expected result? Sheet.

I have attached the file.
Thanks in advance