ExcelBanter - copy a same referance from diffrent worksheet on another file

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy a same referance from diffrent worksheet on another file (https://www.excelbanter.com/excel-worksheet-functions/78953-copy-same-referance-diffrent-worksheet-another-file.html)

copy

copy a same referance from diffrent worksheet on another file

i want to gathet data from saveral work sheet in the single sheet.
data having the same referance number like every worksheet contain data in
A1 cell

Regards
PSP

All times are GMT +1. The time now is 08:34 PM.