pull data from cell

[tintin1012000]

Im looking for code to do the following

I have a file located in W:\APM\Prodqty\Electronic Shift Book\8882\Line 6\wk40.xls
The data in in work sheet called flipchart and the cell is A789

The file on the server is changed every week to wk40.xls to wk41.xls to wk 42.xls and so on

The file where I will use the code also has wk40 in its title File 8882WK4011 nexts week file will be called 8882wk4111 etc

Any ideas on how to solve this one

 

[tintin1012000]

Missed one point, I want to put the cell data form A789 to a work sheet in the 8882wk4011 called plan and cell b52