Formula Needed to Link Two Partial Values into Third Cell

Hello all,

I have two sheets I'm working with in my workbook. The first sheet is called 'Data Entry', and the second is called 'Inspection Report'.

On the Data Entry sheet, there are two cells that receive data.
The first is the A Cell where data is entered in Cell B3:H3 in the format of the following example:
1234567890

The second is the B Cell where data is entered in Cell B4:F4 in the format of the following examples:
0010
0020
0030
0040
0050
0060
0070
0080
0090
0100
0110
0120
etc. (will never exceed 0990)

On the Inspection Report sheet, there's a C Cell which contains Cell C3:I3. I would need a formula in this cell which would be linked to the values of the A Cell as well as part the number from the B Cell, displaying the two data entries as one, separated by a '-'.

To clarify:

Example 1:
On the Data Entry Sheet:
A Cell= 1234567890
B Cell= 0030

On the Inspection Report Sheet:
C Cell now reads 1234567890-3

Example 2:
On the Data Entry Sheet:
A Cell= 5555566666
B Cell= 0110

On the Inspection Report Sheet:
C Cell now reads 5555566666-11

Can this be done through a formula in the C Cell? Any and all help is greatly appreciated, thank you! And have an awesome day!

Hey thanks! A problem arises, however, for values over 0090 that actually require a 0, such as 0100, which currently becomes a -1 instead of a -10. Is there a way around this?

And yes, I'm quite aware of the 'thing' with the merged cells, however, if you saw the full worksheet you'd see the need for them as I do.