Search for 3 digit number in a four digit number

Hi everyone,

Can anyone please create a VBA code to search a 3 digit number in many four digit numbers and count how many that are there? Let me explain more descriptively, in my worksheet, there are many 4 digit numbers, and I want to know how much times a certain 3 digit number appeared in my worksheet. In 1234, there is, 123,124,134,234, right? Okay, so if I want to search for like a 234 in my worksheet, the computer should recognize 1234, or 4321 or 4123 or any number that have 234(in any order like 432,342, and so on) and count how many are there. Please help. Here is one small part of my worksheet.