The distribution of the surname Collingwood at the time of the 1881 census, from http://gbnames.publicprofiler.org/. This shows clearly where the surname was commonest, and the areas where your Collingwood ancestors are most likely to be found.