Transfer of data between two workbooks using name of worksheet?

[laughterbattle]

Hi all - I'm completely new to using VBA and macros and I amwondering if it can be used to improve a data entry process that is currentlydone manually.
Basically, the process is roughly as follows:
· Workbook1
o Several Worksheets (A, B, C etc.)
o Each Worksheet has data for individual companiesin a standard format
Reference Company Value

· Workbook2
o Several Worksheets with the same namingconvention relating to the same companies as in Workbook1
o Each Worksheet has blank cells into which datafrom the corresponding Worksheet in Workbook1 must be entered

· For each ‘company’, what is effectively beingdone under a manual process is a VLOOKUP for the value in each Worksheet in Workbook1so that the values are displayed in each Worksheet in Workbook2.
My question is, could a VBA macro automate this process toupdate each Worksheet in Workbook2 by referring to the corresponding sheet inWorkbook1 which has the same name? I hope it can, but can't seem to find anyonline materials which describe how to program this specifically.
Any help is much appreciated!

 

[mumps]

There are a few ways this can be done but it all depends on how your data is organized. I think that it would be easier to help and test possible solutions if I could work with your actual file which includes any macros you are currently using. Perhaps you could upload a copy of your 2 files to a free site such as www.box.com or www.dropbox.com. Once you do that, mark each file for 'Sharing' and you will be given a link to each file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.