You will get better response(s) if you attach a sample workbook (not pictures of your sheets) with just enough data for us to work with.

Why the 'object required error' on the second line---> VBA considers SOL to be a variable not a worksheet.
Using Option Explicit the VBA would have indicated this before running the macro.
As-is, should be Sheets("SOL").

I suspect you'll get another error on that line because there is no bottom row for the CountIf range.

For loading those text boxes and writing back to the SOL sheet there are different ways,
my personal preference is using the Range.Find Method to locate Me.Shop_TB2.value, then using offset.

Writing to the "Tool Room" sheet...
I imagine Tool Maker is Me.Name_TB2, Tool Number is Me.PartNum_TB2, Date Completed is Me.Complete_TB2,
but don't know what Hours is, nor where any of these should be written on the sheet.