Quick Macro to Reformat Data into specific format

Hi All,

I'm incredibly new to VBA (still) and could use some help with this!

I've attached a file that shows some data in Sheet 1 that I need to be output into Sheet 2 quickly by a macro. There will be thousands of rows of data like this, but they will be together.

The relevant columns are A, F, and G, as they contain the data that needs to be in the output.

The format of the output I need is in Sheet 2, with the following specifics:

Column A - needs to be in "000#" format so if the input value is a "3", then the output needs to be "0003"
Column B - There will be a 6 digit number from the F column in Sheet 1, that needs to be output to "####-##-##", so basically adding dashes between the numbers.

Can anyone help me with this? I would greatly appreciate it.

Thanks!