For example worksheet 1 Column A B C D & E have multiple
Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 &
2038. Worksheet 2, 3 & 4 Have the same.
What i want to acheive is something to look at each
column in each worksheet and count, how many times each
number appears and bring back a result for each in a
different worksheet.