copy new data to below of all record

Please refer pic here:

https://www.excelforum.com/attachments/excel-general/803907d1667794135-copy-new-data-to-below-of-all-record-report-widya.jpg 

red crop A is a data which contains a formula and vlookup to another sheet.

How can I copy red crop A to below of all items in table B in 1 shot?

Just make is showing same with the 2 above (500 & 502.1C)?