Populate master sheet from data on multiple sheets

What I am looking for, there is a thread right on the front page that seems to be what I want exactly, but I couldn't get it to adapt to my sheet.

What I want is to populate a master sheet based on the values of 6 cells across 400+ sheets.

All the information is stored in the same cell on all sheets.

Master sheet and headers on the master are already created.

Headers on master are as follows:
A1 - Account Name
B1 - Bank Name
C1 - Sort Code
D1 - Acct #
E1 - BIC/SWIFT
F1 - IBAN

On each worksheet in the book the data to populate Master are in

Account Name - J21
Bank Name - J23
Sort Code - J25
Acct # - J27
BIC/SWIFT - J43
IBAN - J45


I've attached a sample book.

THANKS!

Try the attached.

Precisely that, thank you AB33!

Shorter version

Please Login or Register  to view this content.

AB, works great! Can you add in there somewhere that if the cell is blank that it carries over a blank? As it stands, if there is a blank cell, it will pull data from the next sheets cell.

Thanks a bunch!

Do you mean if .Range("J21") value is blank, the code is not copying the blank value? Which code? Both?

Corrected both codes.

Thats the ticket! Thanks a bunch.