two questions.

1) how do i add to a selected consolidated field source data from another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff