worksheet name and cell value

[novice2008]

I have several worksheets (say, Sheet 1 to Sheet 6) in a workbook (say, "ProfileDetails"). I would like to enter into the same location (say, A1) of each of these worksheets a value that is to be found in another workbook (say Sheet 1 of "listofnames") in a sequential fashion by rows. That is, Sheet 1 of "ProfileDetails" workbook should receive the value in A1 of Sheet 1 of "listofnames" workbook, Sheet 2 of "ProfileDetails" workbook should receive the value in A2 of Sheet1 of "listofnames" workbook, etc until A1 in all six sheets in "ProfileDetails" workbook have been filled with values in A1 to A6 of Sheet1 of "listofnames" workbook.

Please answer in relatively lay person's level.

Thanks for your help.

[MMULT]

1. fill in formula =[listfnames.xls]sheet1!$A1 in the A1 of profiledetails, =[listfnames.xls]sheet2!$A1 in the sheet of profiledetails...
2. select all sheets in profiledetails
3. drag A1 cell and fill in range A1:A6
done.

[sglife]

If you want to fill only 1 cell on 6 sheets, then you can key in manully one by one.
If you want to fill many cells, give us a sample of your file. Because we need to know the structure of the 2 workbooks.