Duplicate row base on value given

Hi there,


Need help to build a vb script macro to duplicate the entire row base on the value given in Column A, the duplicates will be in sheet 2 always starting from A1. For example duplicate the row of B2 and C2 5 times, which is based on the value in A2. I may need to add in more columns in the future in D, E and so on.

Attached is the example in the file attached
Please do help

Thanks