Excel 2007 : formula for copying data to worksheets using a userform

[meeatloaffan1965]

Hi all
I hope you will be able to help me. I have created a workbook which has 7 worksheets in it. I have started to create a userform called financial year end. What i want to do is sort by the financial year end and only the name of the buildings that have the year end will copy into the next 7 worksheets. But im having problems creating the correct formula.

[Palmetto]

In order to get a precise answer you will need to upload a sample workbook that meets this criteria:

1. It exactly duplicates the structure of your real workbook AND,
2. It contains representative but non-sensitive dummy data, AND
3. It manually illustrates the desired outcome