I have a workbook with numerous worksheets. Every worksheet is set up the
same with the same headers etc. and the last row of text (which varies each
day) is a sum total of the values in column F. What I want to do is use some
type of code to say to copy the last cell in column F in worksheet A and
place it in the Sheet titled "Summary" in cell C4. Then do the same for the
other documents in the Workbook, for example

Last populated Cell in Col F in WS A copy to cell C4 in Summary Document
Last populated Cell in Col F in WS B copy to cell C6 in Summary Document
Last populated Cell in Col F in WS C copy to cell C8 in Summary Document.
Last popluated Cell in Col F in WS D copy to cell C10 in Summary Document

Can this be done with VBA? Thanks for your help.